<div class='container_12'>
    <div class='grid_12 alpha omega'>
        <p><?php echo $title;?></p>
        
        <?php
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `account` (
                          `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                          `username` varchar(24) NOT NULL,
                          `email` varchar(160) NOT NULL,
                          `password` varchar(60) DEFAULT NULL,
                          `is_admin` tinyint(4) DEFAULT NULL,
                          `createdon` datetime NOT NULL,
                          `verifiedon` datetime DEFAULT NULL,
                          `lastsignedinon` datetime DEFAULT NULL,
                          `resetsenton` datetime DEFAULT NULL,
                          `deletedon` datetime DEFAULT NULL,
                          `suspendedon` datetime DEFAULT NULL,
						  `payed` tinyint(4) NOT NULL DEFAULT '0',
                          PRIMARY KEY (`id`),
                          UNIQUE KEY `username` (`username`),
                          UNIQUE KEY `email` (`email`)
                        )";
        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `account_details` (
                          `account_id` bigint(20) unsigned NOT NULL,
                          `fullname` varchar(160) DEFAULT NULL,
                          `firstname` varchar(80) DEFAULT NULL,
                          `lastname` varchar(80) DEFAULT NULL,
                          `pred_total_goals` int(11) DEFAULT NULL,
                          `pred_champion` varchar(4) DEFAULT NULL,
                          `company` varchar(80) DEFAULT NULL,
                          `dateofbirth` date DEFAULT NULL,
                          `gender` char(1) DEFAULT NULL,
                          `postalcode` varchar(40) DEFAULT NULL,
                          `country` char(2) DEFAULT NULL,
                          `language` char(2) DEFAULT NULL,
                          `timezone` varchar(40) DEFAULT NULL,
                          `picture` varchar(240) DEFAULT NULL,
                          `pool_style` varchar(10) DEFAULT NULL,
                          PRIMARY KEY (`account_id`)
                        )";
        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `account_facebook` (
                          `account_id` bigint(20) NOT NULL,
                          `facebook_id` bigint(20) NOT NULL,
                          `linkedon` datetime NOT NULL,
                          PRIMARY KEY (`account_id`),
                          UNIQUE KEY `facebook_id` (`facebook_id`)
                        )";
                        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `account_openid` (
                          `openid` varchar(240) NOT NULL,
                          `account_id` bigint(20) unsigned NOT NULL,
                          `linkedon` datetime NOT NULL,
                          PRIMARY KEY (`openid`),
                          KEY `account_id` (`account_id`)
                        )";
        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `account_twitter` (
                          `account_id` bigint(20) NOT NULL,
                          `twitter_id` bigint(20) NOT NULL,
                          `oauth_token` varchar(80) NOT NULL,
                          `oauth_token_secret` varchar(80) NOT NULL,
                          `linkedon` datetime NOT NULL,
                          PRIMARY KEY (`account_id`),
                          KEY `twitter_id` (`twitter_id`)
                        )";
                        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `ci_session` (
                          `session_id` varchar(40) NOT NULL DEFAULT '0',
                          `ip_address` varchar(16) NOT NULL DEFAULT '0',
                          `user_agent` varchar(50) NOT NULL,
                          `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
                          `user_data` text NOT NULL,
                          PRIMARY KEY (`session_id`)
                        )";

        $sql_query[] = "CREATE TABLE IF NOT EXISTS `match` (
                          `match_uid` int(11) NOT NULL,
                          `home_team` varchar(4) NOT NULL,
                          `away_team` varchar(4) NOT NULL,
                          `home_goals` int(11) DEFAULT NULL,
                          `away_goals` int(11) DEFAULT NULL,
                          `winning_team` varchar(4) DEFAULT NULL,
                          `timestamp` int(11) NOT NULL,
                          `match_group` varchar(4) NOT NULL,
                          `match_group_home_team` varchar(10) DEFAULT NULL,
                          `match_group_away_team` varchar(10) DEFAULT NULL,
                          `match_calculated` tinyint(4) NOT NULL DEFAULT '0',
                          PRIMARY KEY (`match_uid`)
                        )";
                        
        $sql_query[] = "REPLACE INTO `match` (`match_uid`, `home_team`, `away_team`, `home_goals`, `away_goals`, `winning_team`, `timestamp`, `match_group`, `match_group_home_team`, `match_group_away_team`, `match_calculated`) VALUES
                                            (1, 'A1', 'A2', NULL, NULL, NULL, 1339171200, 'A', '', '', 0),
                                            (2, 'A3', 'A4', NULL, NULL, NULL, 1339181100, 'A', '', '', 0),
                                            (3, 'B1', 'B2', NULL, NULL, NULL, 1339257600, 'B', '', '', 0),
                                            (4, 'B3', 'B4', NULL, NULL, NULL, 1339267500, 'B', '', '', 0),
                                            (5, 'C1', 'C2', NULL, NULL, NULL, 1339344000, 'C', '', '', 0),
                                            (6, 'C3', 'C4', NULL, NULL, NULL, 1339353900, 'C', '', '', 0),
                                            (7, 'D3', 'D4', NULL, NULL, NULL, 1339430400, 'D', '', '', 0),
                                            (8, 'D1', 'D2', NULL, NULL, NULL, 1339440300, 'D', '', '', 0),
                                            (9, 'A2', 'A4', NULL, NULL, NULL, 1339516800, 'A', '', '', 0),
                                            (10, 'A1', 'A3', NULL, NULL, NULL, 1339526700, 'A', '', '', 0),
                                            (11, 'B2', 'B4', NULL, NULL, NULL, 1339603200, 'B', '', '', 0),
                                            (12, 'B1', 'B3', NULL, NULL, NULL, 1339613100, 'B', '', '', 0),
                                            (13, 'C2', 'C4', NULL, NULL, NULL, 1339689600, 'C', '', '', 0),
                                            (14, 'C1', 'C3', NULL, NULL, NULL, 1339699500, 'C', '', '', 0),
                                            (15, 'D2', 'D4', NULL, NULL, NULL, 1339785900, 'D', '', '', 0),
                                            (16, 'D1', 'D3', NULL, NULL, NULL, 1339776000, 'D', '', '', 0),
                                            (17, 'A4', 'A1', NULL, NULL, NULL, 1339872300, 'A', '', '', 0),
                                            (18, 'A2', 'A3', NULL, NULL, NULL, 1339872300, 'A', '', '', 0),
                                            (19, 'B4', 'B1', NULL, NULL, NULL, 1339958700, 'B', '', '', 0),
                                            (20, 'B2', 'B3', NULL, NULL, NULL, 1339958700, 'B', '', '', 0),
                                            (21, 'C4', 'C1', NULL, NULL, NULL, 1340045100, 'C', '', '', 0),
                                            (22, 'C2', 'C3', NULL, NULL, NULL, 1340045100, 'C', '', '', 0),
                                            (23, 'D4', 'D1', NULL, NULL, NULL, 1340131500, 'D', '', '', 0),
                                            (24, 'D2', 'D3', NULL, NULL, NULL, 1340131500, 'D', '', '', 0),
                                            (25, 'WA', 'RB', NULL, NULL, NULL, 1340304300, 'QF', 'A', 'B', 0),
                                            (26, 'WB', 'RA', NULL, NULL, NULL, 1340390700, 'QF', 'B', 'A', 0),
                                            (27, 'WC', 'RD', NULL, NULL, NULL, 1340477100, 'QF', 'C', 'D', 0),
                                            (28, 'WD', 'RC', NULL, NULL, NULL, 1340563500, 'QF', 'D', 'C', 0),
                                            (29, 'W25', 'W27', NULL, NULL, NULL, 1340822700, 'SF', 'A,B', 'C,D', 0),
                                            (30, 'W26', 'W28', NULL, NULL, NULL, 1340909100, 'SF', 'A,B', 'C,D', 0),
                                            (31, 'W29', 'W30', NULL, NULL, NULL, 1341168300, 'F', 'A,B,C,D', 'A,B,C,D', 0)";
                        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `prediction` (
                          `prediction_uid` bigint(11) NOT NULL AUTO_INCREMENT,
                          `account_id` bigint(20) NOT NULL,
                          `pred_match_uid` int(11) NOT NULL,
                          `pred_home_goals` int(11) DEFAULT NULL,
                          `pred_away_goals` int(11) DEFAULT NULL,
                          `pred_home_team` varchar(4) DEFAULT NULL,
                          `pred_away_team` varchar(4) DEFAULT NULL,
                          `pred_points_home_goals` int(11) NOT NULL DEFAULT '0',
                          `pred_points_away_goals` int(11) NOT NULL DEFAULT '0',
                          `pred_points_result` int(11) NOT NULL DEFAULT '0',
                          `pred_points_bonus` int(11) NOT NULL DEFAULT '0',
                          `pred_points_home_team` int(11) NOT NULL DEFAULT '0',
                          `pred_points_away_team` int(11) NOT NULL DEFAULT '0',
                          `pred_points_total` int(11) NULL DEFAULT '0',
                          `pred_calculated` tinyint(4) NOT NULL DEFAULT '0',
                          PRIMARY KEY (`prediction_uid`)
                        )";
                        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `ref_country` (
                          `alpha2` char(2) NOT NULL,
                          `alpha3` char(3) NOT NULL,
                          `numeric` varchar(3) NOT NULL,
                          `country` varchar(80) NOT NULL,
                          PRIMARY KEY (`alpha2`),
                          UNIQUE KEY `alpha3` (`alpha3`)
                        )";

        $sql_query[] = "REPLACE INTO `ref_country` (`alpha2`, `alpha3`, `numeric`, `country`) VALUES
                        ('ao', 'ago', '024', 'Angola'),
                        ('ai', 'aia', '660', 'Anguilla'),
                        ('aq', 'ata', '010', 'Antarctica'),
                        ('ag', 'atg', '028', 'Antigua and Barbuda'),
                        ('ar', 'arg', '032', 'Argentina'),
                        ('am', 'arm', '051', 'Armenia'),
                        ('aw', 'abw', '533', 'Aruba'),
                        ('au', 'aus', '036', 'Australia'),
                        ('at', 'aut', '040', 'Austria'),
                        ('az', 'aze', '031', 'Azerbaijan'),
                        ('bs', 'bhs', '044', 'Bahamas'),
                        ('bh', 'bhr', '048', 'Bahrain'),
                        ('bd', 'bgd', '050', 'Bangladesh'),
                        ('bb', 'brb', '052', 'Barbados'),
                        ('by', 'blr', '112', 'Belarus'),
                        ('be', 'bel', '056', 'Belgium'),
                        ('bz', 'blz', '084', 'Belize'),
                        ('bj', 'ben', '204', 'Benin'),
                        ('bm', 'bmu', '060', 'Bermuda'),
                        ('bt', 'btn', '064', 'Bhutan'),
                        ('bo', 'bol', '068', 'Bolivia, Plurinational State of'),
                        ('ba', 'bih', '070', 'Bosnia and Herzegovina'),
                        ('bw', 'bwa', '072', 'Botswana'),
                        ('bv', 'bvt', '074', 'Bouvet Island'),
                        ('br', 'bra', '076', 'Brazil'),
                        ('io', 'iot', '086', 'British Indian Ocean Territory'),
                        ('bn', 'brn', '096', 'Brunei Darussalam'),
                        ('bg', 'bgr', '100', 'Bulgaria'),
                        ('bf', 'bfa', '854', 'Burkina Faso'),
                        ('bi', 'bdi', '108', 'Burundi'),
                        ('kh', 'khm', '116', 'Cambodia'),
                        ('cm', 'cmr', '120', 'Cameroon'),
                        ('ca', 'can', '124', 'Canada'),
                        ('cv', 'cpv', '132', 'Cape Verde'),
                        ('ky', 'cym', '136', 'Cayman Islands'),
                        ('cf', 'caf', '140', 'Central African Republic'),
                        ('td', 'tcd', '148', 'Chad'),
                        ('cl', 'chl', '152', 'Chile'),
                        ('cn', 'chn', '156', 'China'),
                        ('cx', 'cxr', '162', 'Christmas Island'),
                        ('cc', 'cck', '166', 'Cocos (Keeling) Islands'),
                        ('co', 'col', '170', 'Colombia'),
                        ('km', 'com', '174', 'Comoros'),
                        ('cg', 'cog', '178', 'Congo'),
                        ('cd', 'cod', '180', 'Congo, the Democratic Republic of the'),
                        ('ck', 'cok', '184', 'Cook Islands'),
                        ('cr', 'cri', '188', 'Costa Rica'),
                        ('ci', 'civ', '384', 'Côte d''Ivoire'),
                        ('hr', 'hrv', '191', 'Croatia'),
                        ('cu', 'cub', '192', 'Cuba'),
                        ('cy', 'cyp', '196', 'Cyprus'),
                        ('cz', 'cze', '203', 'Czech Republic'),
                        ('dk', 'dnk', '208', 'Denmark'),
                        ('dj', 'dji', '262', 'Djibouti'),
                        ('dm', 'dma', '212', 'Dominica'),
                        ('do', 'dom', '214', 'Dominican Republic'),
                        ('ec', 'ecu', '218', 'Ecuador'),
                        ('eg', 'egy', '818', 'Egypt'),
                        ('sv', 'slv', '222', 'El Salvador'),
                        ('gq', 'gnq', '226', 'Equatorial Guinea'),
                        ('er', 'eri', '232', 'Eritrea'),
                        ('ee', 'est', '233', 'Estonia'),
                        ('et', 'eth', '231', 'Ethiopia'),
                        ('fk', 'flk', '238', 'Falkland Islands (Malvinas)'),
                        ('fo', 'fro', '234', 'Faroe Islands'),
                        ('fj', 'fji', '242', 'Fiji'),
                        ('fi', 'fin', '246', 'Finland'),
                        ('fr', 'fra', '250', 'France'),
                        ('gf', 'guf', '254', 'French Guiana'),
                        ('pf', 'pyf', '258', 'French Polynesia'),
                        ('tf', 'atf', '260', 'French Southern Territories'),
                        ('ga', 'gab', '266', 'Gabon'),
                        ('gm', 'gmb', '270', 'Gambia'),
                        ('ge', 'geo', '268', 'Georgia'),
                        ('de', 'deu', '276', 'Germany'),
                        ('gh', 'gha', '288', 'Ghana'),
                        ('gi', 'gib', '292', 'Gibraltar'),
                        ('gr', 'grc', '300', 'Greece'),
                        ('gl', 'grl', '304', 'Greenland'),
                        ('gd', 'grd', '308', 'Grenada'),
                        ('gp', 'glp', '312', 'Guadeloupe'),
                        ('gu', 'gum', '316', 'Guam'),
                        ('gt', 'gtm', '320', 'Guatemala'),
                        ('gg', 'ggy', '831', 'Guernsey'),
                        ('gn', 'gin', '324', 'Guinea'),
                        ('gw', 'gnb', '624', 'Guinea-Bissau'),
                        ('gy', 'guy', '328', 'Guyana'),
                        ('ht', 'hti', '332', 'Haiti'),
                        ('hm', 'hmd', '334', 'Heard Island and McDonald Islands'),
                        ('va', 'vat', '336', 'Holy See (Vatican City State)'),
                        ('hn', 'hnd', '340', 'Honduras'),
                        ('hk', 'hkg', '344', 'Hong Kong'),
                        ('hu', 'hun', '348', 'Hungary'),
                        ('is', 'isl', '352', 'Iceland'),
                        ('in', 'ind', '356', 'India'),
                        ('id', 'idn', '360', 'Indonesia'),
                        ('ir', 'irn', '364', 'Iran, Islamic Republic of'),
                        ('iq', 'irq', '368', 'Iraq'),
                        ('ie', 'irl', '372', 'Ireland'),
                        ('im', 'imn', '833', 'Isle of Man'),
                        ('il', 'isr', '376', 'Israel'),
                        ('it', 'ita', '380', 'Italy'),
                        ('jm', 'jam', '388', 'Jamaica'),
                        ('jp', 'jpn', '392', 'Japan'),
                        ('je', 'jey', '832', 'Jersey'),
                        ('jo', 'jor', '400', 'Jordan'),
                        ('kz', 'kaz', '398', 'Kazakhstan'),
                        ('ke', 'ken', '404', 'Kenya'),
                        ('ki', 'kir', '296', 'Kiribati'),
                        ('kp', 'prk', '408', 'Korea, Democratic People''s Republic of'),
                        ('kr', 'kor', '410', 'Korea, Republic of'),
                        ('kw', 'kwt', '414', 'Kuwait'),
                        ('kg', 'kgz', '417', 'Kyrgyzstan'),
                        ('la', 'lao', '418', 'Lao People''s Democratic Republic'),
                        ('lv', 'lva', '428', 'Latvia'),
                        ('lb', 'lbn', '422', 'Lebanon'),
                        ('ls', 'lso', '426', 'Lesotho'),
                        ('lr', 'lbr', '430', 'Liberia'),
                        ('ly', 'lby', '434', 'Libyan Arab Jamahiriya'),
                        ('li', 'lie', '438', 'Liechtenstein'),
                        ('lt', 'ltu', '440', 'Lithuania'),
                        ('lu', 'lux', '442', 'Luxembourg'),
                        ('mo', 'mac', '446', 'Macao'),
                        ('mk', 'mkd', '807', 'Macedonia, the former Yugoslav Republic of'),
                        ('mg', 'mdg', '450', 'Madagascar'),
                        ('mw', 'mwi', '454', 'Malawi'),
                        ('my', 'mys', '458', 'Malaysia'),
                        ('mv', 'mdv', '462', 'Maldives'),
                        ('ml', 'mli', '466', 'Mali'),
                        ('mt', 'mlt', '470', 'Malta'),
                        ('mh', 'mhl', '584', 'Marshall Islands'),
                        ('mq', 'mtq', '474', 'Martinique'),
                        ('mr', 'mrt', '478', 'Mauritania'),
                        ('mu', 'mus', '480', 'Mauritius'),
                        ('yt', 'myt', '175', 'Mayotte'),
                        ('mx', 'mex', '484', 'Mexico'),
                        ('fm', 'fsm', '583', 'Micronesia, Federated States of'),
                        ('md', 'mda', '498', 'Moldova, Republic of'),
                        ('mc', 'mco', '492', 'Monaco'),
                        ('mn', 'mng', '496', 'Mongolia'),
                        ('me', 'mne', '499', 'Montenegro'),
                        ('ms', 'msr', '500', 'Montserrat'),
                        ('ma', 'mar', '504', 'Morocco'),
                        ('mz', 'moz', '508', 'Mozambique'),
                        ('mm', 'mmr', '104', 'Myanmar'),
                        ('na', 'nam', '516', 'Namibia'),
                        ('nr', 'nru', '520', 'Nauru'),
                        ('np', 'npl', '524', 'Nepal'),
                        ('nl', 'nld', '528', 'Netherlands'),
                        ('an', 'ant', '530', 'Netherlands Antilles'),
                        ('nc', 'ncl', '540', 'New Caledonia'),
                        ('nz', 'nzl', '554', 'New Zealand'),
                        ('ni', 'nic', '558', 'Nicaragua'),
                        ('ne', 'ner', '562', 'Niger'),
                        ('ng', 'nga', '566', 'Nigeria'),
                        ('nu', 'niu', '570', 'Niue'),
                        ('nf', 'nfk', '574', 'Norfolk Island'),
                        ('mp', 'mnp', '580', 'Northern Mariana Islands'),
                        ('no', 'nor', '578', 'Norway'),
                        ('om', 'omn', '512', 'Oman'),
                        ('pk', 'pak', '586', 'Pakistan'),
                        ('pw', 'plw', '585', 'Palau'),
                        ('ps', 'pse', '275', 'Palestinian Territory, Occupied'),
                        ('pa', 'pan', '591', 'Panama'),
                        ('pg', 'png', '598', 'Papua New Guinea'),
                        ('py', 'pry', '600', 'Paraguay'),
                        ('pe', 'per', '604', 'Peru'),
                        ('ph', 'phl', '608', 'Philippines'),
                        ('pn', 'pcn', '612', 'Pitcairn'),
                        ('pl', 'pol', '616', 'Poland'),
                        ('pt', 'prt', '620', 'Portugal'),
                        ('pr', 'pri', '630', 'Puerto Rico'),
                        ('qa', 'qat', '634', 'Qatar'),
                        ('re', 'reu', '638', 'Réunion'),
                        ('ro', 'rou', '642', 'Romania'),
                        ('ru', 'rus', '643', 'Russian Federation'),
                        ('rw', 'rwa', '646', 'Rwanda'),
                        ('bl', 'blm', '652', 'Saint Barthélemy'),
                        ('sh', 'shn', '654', 'Saint Helena'),
                        ('kn', 'kna', '659', 'Saint Kitts and Nevis'),
                        ('lc', 'lca', '662', 'Saint Lucia'),
                        ('mf', 'maf', '663', 'Saint Martin (French part)'),
                        ('pm', 'spm', '666', 'Saint Pierre and Miquelon'),
                        ('vc', 'vct', '670', 'Saint Vincent and the Grenadines'),
                        ('ws', 'wsm', '882', 'Samoa'),
                        ('sm', 'smr', '674', 'San Marino'),
                        ('st', 'stp', '678', 'Sao Tome and Principe'),
                        ('sa', 'sau', '682', 'Saudi Arabia'),
                        ('sn', 'sen', '686', 'Senegal'),
                        ('rs', 'srb', '688', 'Serbia'),
                        ('sc', 'syc', '690', 'Seychelles'),
                        ('sl', 'sle', '694', 'Sierra Leone'),
                        ('sg', 'sgp', '702', 'Singapore'),
                        ('sk', 'svk', '703', 'Slovakia'),
                        ('si', 'svn', '705', 'Slovenia'),
                        ('sb', 'slb', '090', 'Solomon Islands'),
                        ('so', 'som', '706', 'Somalia'),
                        ('za', 'zaf', '710', 'South Africa'),
                        ('gs', 'sgs', '239', 'South Georgia and the South Sandwich Islands'),
                        ('es', 'esp', '724', 'Spain'),
                        ('lk', 'lka', '144', 'Sri Lanka'),
                        ('sd', 'sdn', '736', 'Sudan'),
                        ('sr', 'sur', '740', 'Suriname'),
                        ('sj', 'sjm', '744', 'Svalbard and Jan Mayen'),
                        ('sz', 'swz', '748', 'Swaziland'),
                        ('se', 'swe', '752', 'Sweden'),
                        ('ch', 'che', '756', 'Switzerland'),
                        ('sy', 'syr', '760', 'Syrian Arab Republic'),
                        ('tw', 'twn', '158', 'Taiwan, Province of China'),
                        ('tj', 'tjk', '762', 'Tajikistan'),
                        ('tz', 'tza', '834', 'Tanzania, United Republic of'),
                        ('th', 'tha', '764', 'Thailand'),
                        ('tl', 'tls', '626', 'Timor-Leste'),
                        ('tg', 'tgo', '768', 'Togo'),
                        ('tk', 'tkl', '772', 'Tokelau'),
                        ('to', 'ton', '776', 'Tonga'),
                        ('tt', 'tto', '780', 'Trinidad and Tobago'),
                        ('tn', 'tun', '788', 'Tunisia'),
                        ('tr', 'tur', '792', 'Turkey'),
                        ('tm', 'tkm', '795', 'Turkmenistan'),
                        ('tc', 'tca', '796', 'Turks and Caicos Islands'),
                        ('tv', 'tuv', '798', 'Tuvalu'),
                        ('ug', 'uga', '800', 'Uganda'),
                        ('ua', 'ukr', '804', 'Ukraine'),
                        ('ae', 'are', '784', 'United Arab Emirates'),
                        ('gb', 'gbr', '826', 'United Kingdom'),
                        ('us', 'usa', '840', 'United States'),
                        ('um', 'umi', '581', 'United States Minor Outlying Islands'),
                        ('uy', 'ury', '858', 'Uruguay'),
                        ('uz', 'uzb', '860', 'Uzbekistan'),
                        ('vu', 'vut', '548', 'Vanuatu'),
                        ('ve', 'ven', '862', 'Venezuela, Bolivarian Republic of'),
                        ('vn', 'vnm', '704', 'Viet Nam'),
                        ('vg', 'vgb', '092', 'Virgin Islands, British'),
                        ('vi', 'vir', '850', 'Virgin Islands, U.S.'),
                        ('wf', 'wlf', '876', 'Wallis and Futuna'),
                        ('eh', 'esh', '732', 'Western Sahara'),
                        ('ye', 'yem', '887', 'Yemen'),
                        ('zm', 'zmb', '894', 'Zambia'),
                        ('zw', 'zwe', '716', 'Zimbabwe'),
                        ('af', 'afg', '004', 'Afghanistan'),
                        ('ax', 'ala', '248', 'Åland Islands'),
                        ('al', 'alb', '008', 'Albania'),
                        ('dz', 'dza', '012', 'Algeria'),
                        ('as', 'asm', '016', 'American Samoa'),
                        ('ad', 'and', '020', 'Andorra')";
                        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `ref_currency` (
                          `alpha` char(3) NOT NULL,
                          `numeric` varchar(3) DEFAULT NULL,
                          `currency` varchar(80) NOT NULL,
                          PRIMARY KEY (`alpha`),
                          KEY `numeric` (`numeric`)
                        )";

        $sql_query[] = "REPLACE INTO `ref_currency` (`alpha`, `numeric`, `currency`) VALUES
                        ('EUR', '978', 'Euro'),
                        ('USD', '840', 'US Dollar'),
                        ('PLN', '985', 'Zloty')";
                        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `ref_iptocountry` (
                          `ip_from` int(10) unsigned NOT NULL,
                          `ip_to` int(10) unsigned NOT NULL,
                          `country_code` char(2) NOT NULL,
                          KEY `country_code` (`country_code`),
                          KEY `ip_to` (`ip_to`),
                          KEY `ip_from` (`ip_from`)
                        )";

        $sql_query[] = "REPLACE INTO `ref_iptocountry` (`ip_from`, `ip_to`, `country_code`) VALUES
                            (214858656, 214858671, 'nl'),
                            (411303936, 411369471, 'nl'),
                            (540711936, 540712447, 'nl'),
                            (1040468736, 1040468767, 'nl'),
                            (1040468800, 1040468831, 'nl'),
                            (1040468864, 1040468991, 'nl'),
                            (1040470784, 1040471295, 'nl'),
                            (1040471488, 1040471711, 'nl'),
                            (1040471744, 1040471775, 'nl'),
                            (1040472992, 1040473343, 'nl'),
                            (1040473856, 1040474111, 'nl'),
                            (1040973824, 1040982015, 'nl'),
                            (1040982664, 1040982679, 'nl'),
                            (1041596416, 1041629183, 'nl'),
                            (1041825792, 1041842175, 'nl'),
                            (1042292736, 1042293247, 'nl'),
                            (1042293504, 1042293535, 'nl'),
                            (1042296832, 1042297215, 'nl'),
                            (1042297856, 1042298111, 'nl'),
                            (1042298144, 1042298175, 'nl'),
                            (1042298352, 1042298367, 'nl'),
                            (1042298624, 1042298879, 'nl'),
                            (1042299392, 1042300159, 'nl'),
                            (1042300416, 1042300479, 'nl'),
                            (1042300640, 1042300647, 'nl'),
                            (1042300912, 1042300919, 'nl'),
                            (1042874368, 1042875903, 'nl'),
                            (1042876160, 1042876415, 'nl'),
                            (1042876480, 1042876671, 'nl'),
                            (1042876928, 1042880639, 'nl'),
                            (1042880768, 1042882559, 'nl'),
                            (1042882816, 1042888703, 'nl'),
                            (1042888960, 1042889215, 'nl'),
                            (1042889472, 1042889983, 'nl'),
                            (1042890112, 1042890751, 'nl'),
                            (1042890784, 1042890815, 'nl'),
                            (1042890820, 1042890847, 'nl'),
                            (1042890880, 1042890944, 'nl'),
                            (1042890951, 1042890959, 'nl'),
                            (1042890992, 1042891775, 'nl'),
                            (1042891840, 1042892015, 'nl'),
                            (1042892032, 1042892287, 'nl'),
                            (1042892544, 1042892863, 'nl'),
                            (1042892928, 1042892967, 'nl'),
                            (1042892984, 1042893055, 'nl'),
                            (1042893088, 1042893135, 'nl'),
                            (1042893144, 1042893183, 'nl'),
                            (1042893312, 1042894079, 'nl'),
                            (1042894176, 1042894559, 'nl'),
                            (1042894656, 1042894783, 'nl'),
                            (1042894848, 1042895359, 'nl'),
                            (1042895872, 1042900479, 'nl'),
                            (1042900736, 1042939903, 'nl'),
                            (1043136512, 1043202047, 'nl'),
                            (1043464192, 1043465215, 'nl'),
                            (1043529728, 1043562495, 'nl'),
                            (1043988480, 1043988487, 'nl'),
                            (1043988496, 1043988503, 'nl'),
                            (1043988512, 1043988527, 'nl'),
                            (1043988552, 1043988559, 'nl'),
                            (1043988576, 1043988607, 'nl'),
                            (1043988640, 1043988647, 'nl'),
                            (1043988656, 1043988663, 'nl'),
                            (1043988680, 1043988711, 'nl'),
                            (1043988720, 1043988727, 'nl'),
                            (1043988736, 1043988767, 'nl'),
                            (1043988776, 1043988799, 'nl'),
                            (1043988824, 1043988943, 'nl'),
                            (1043989120, 1043989503, 'nl'),
                            (1043989536, 1043989543, 'nl'),
                            (1043989568, 1043989599, 'nl'),
                            (1043989640, 1043989655, 'nl'),
                            (1043989664, 1043989695, 'nl'),
                            (1043989752, 1043990015, 'nl'),
                            (1043990272, 1043990367, 'nl'),
                            (1043990528, 1043990543, 'nl'),
                            (1043990560, 1043990591, 'nl'),
                            (1043990616, 1043990623, 'nl'),
                            (1043990632, 1043990783, 'nl'),
                            (1043991040, 1043991063, 'nl'),
                            (1043991072, 1043991231, 'nl'),
                            (1043992064, 1043992319, 'nl'),
                            (1043992576, 1043992735, 'nl'),
                            (1043992768, 1043992831, 'nl'),
                            (1043993600, 1043993855, 'nl'),
                            (1043994644, 1043994651, 'nl'),
                            (1043994656, 1043994699, 'nl'),
                            (1043994704, 1043994707, 'nl'),
                            (1043994712, 1043994747, 'nl'),
                            (1043994756, 1043994759, 'nl'),
                            (1043994792, 1043994795, 'nl'),
                            (1043994812, 1043994815, 'nl'),
                            (1043994852, 1043994855, 'nl'),
                            (1043994864, 1043994867, 'nl'),
                            (1043994872, 1043994875, 'nl'),
                            (1043994880, 1043994887, 'nl'),
                            (1043994908, 1043994911, 'nl'),
                            (1043994932, 1043994935, 'nl'),
                            (1043994976, 1043994979, 'nl'),
                            (1043994988, 1043994991, 'nl'),
                            (1043994996, 1043995003, 'nl'),
                            (1043995024, 1043995027, 'nl'),
                            (1043995036, 1043995051, 'nl'),
                            (1043995060, 1043995067, 'nl'),
                            (1043995104, 1043995115, 'nl'),
                            (1043995128, 1043995131, 'nl'),
                            (1043995136, 1043995139, 'nl'),
                            (1043995152, 1043995155, 'nl'),
                            (1043995172, 1043995175, 'nl'),
                            (1043995184, 1043995187, 'nl'),
                            (1043995216, 1043995223, 'nl'),
                            (1043995236, 1043995239, 'nl'),
                            (1043995264, 1043995267, 'nl'),
                            (1043995280, 1043995283, 'nl'),
                            (1043995292, 1043995295, 'nl'),
                            (1043995304, 1043995311, 'nl'),
                            (1043995664, 1043995687, 'nl'),
                            (1043995696, 1043995703, 'nl'),
                            (1043995720, 1043995735, 'nl'),
                            (1043995744, 1043995759, 'nl'),
                            (1043995768, 1043995783, 'nl'),
                            (1043995808, 1043995831, 'nl'),
                            (1043995864, 1043995887, 'nl'),
                            (1043995904, 1043995935, 'nl'),
                            (1043995944, 1043995951, 'nl'),
                            (1043995976, 1043995999, 'nl'),
                            (1043996016, 1043996023, 'nl'),
                            (1043996096, 1043996103, 'nl'),
                            (1043996112, 1043996119, 'nl'),
                            (1043996144, 1043996151, 'nl'),
                            (1043996160, 1043996687, 'nl'),
                            (1043996704, 1043996815, 'nl'),
                            (1043996928, 1043997375, 'nl'),
                            (1043997464, 1043997471, 'nl'),
                            (1043997520, 1043997551, 'nl'),
                            (1043997560, 1043997583, 'nl'),
                            (1043997640, 1043997663, 'nl'),
                            (1043997688, 1043997919, 'nl'),
                            (1043998080, 1043998143, 'nl'),
                            (1043998152, 1043998159, 'nl'),
                            (1043998168, 1043998191, 'nl'),
                            (1043998196, 1043998198, 'nl'),
                            (1043998200, 1043998207, 'nl'),
                            (1043998464, 1043998719, 'nl'),
                            (1043998736, 1043998751, 'nl'),
                            (1043998760, 1043998783, 'nl'),
                            (1043998800, 1043998847, 'nl'),
                            (1043998864, 1043998879, 'nl'),
                            (1043998888, 1043998911, 'nl'),
                            (1043998976, 1043998983, 'nl'),
                            (1043999008, 1043999055, 'nl'),
                            (1043999072, 1043999103, 'nl'),
                            (1043999120, 1043999143, 'nl'),
                            (1043999152, 1043999159, 'nl'),
                            (1043999208, 1043999215, 'nl'),
                            (1043999224, 1043999487, 'nl'),
                            (1043999752, 1043999759, 'nl'),
                            (1043999776, 1043999783, 'nl'),
                            (1043999792, 1043999823, 'nl'),
                            (1043999832, 1043999999, 'nl'),
                            (1044000032, 1044000063, 'nl'),
                            (1044000096, 1044000767, 'nl'),
                            (1044000832, 1044000895, 'nl'),
                            (1044000976, 1044000983, 'nl'),
                            (1044001000, 1044001023, 'nl'),
                            (1044001280, 1044001663, 'nl'),
                            (1044001792, 1044001823, 'nl'),
                            (1044001840, 1044001847, 'nl'),
                            (1044001856, 1044001887, 'nl'),
                            (1044001896, 1044001927, 'nl'),
                            (1044001936, 1044002087, 'nl'),
                            (1044002096, 1044002103, 'nl'),
                            (1044002136, 1044002175, 'nl'),
                            (1044002240, 1044002831, 'nl'),
                            (1044002856, 1044002859, 'nl'),
                            (1044002880, 1044002883, 'nl'),
                            (1044002892, 1044002899, 'nl'),
                            (1044002912, 1044002919, 'nl'),
                            (1044002932, 1044002947, 'nl'),
                            (1044002960, 1044002975, 'nl'),
                            (1044002984, 1044002987, 'nl'),
                            (1044003000, 1044003003, 'nl'),
                            (1044003020, 1044003023, 'nl'),
                            (1044003028, 1044003031, 'nl'),
                            (1044003072, 1044003079, 'nl'),
                            (1044003100, 1044003103, 'nl'),
                            (1044003116, 1044003119, 'nl'),
                            (1044003124, 1044003131, 'nl'),
                            (1044003148, 1044003151, 'nl'),
                            (1044003156, 1044003159, 'nl'),
                            (1044003168, 1044003171, 'nl'),
                            (1044003176, 1044003179, 'nl'),
                            (1044003184, 1044003187, 'nl'),
                            (1044003212, 1044003219, 'nl'),
                            (1044003224, 1044003227, 'nl'),
                            (1044003236, 1044003251, 'nl'),
                            (1044003280, 1044003283, 'nl'),
                            (1044003292, 1044003295, 'nl'),
                            (1044003300, 1044003303, 'nl'),
                            (1044003312, 1044003315, 'nl'),
                            (1044003320, 1044003323, 'nl'),
                            (1044003332, 1044003343, 'nl'),
                            (1044003360, 1044003362, 'nl'),
                            (1044003364, 1044003371, 'nl'),
                            (1044003380, 1044003383, 'nl'),
                            (1044003424, 1044003427, 'nl'),
                            (1044003460, 1044003463, 'nl'),
                            (1044003468, 1044003471, 'nl'),
                            (1044003484, 1044003487, 'nl'),
                            (1044003512, 1044003527, 'nl'),
                            (1044003540, 1044003543, 'nl'),
                            (1044003552, 1044003563, 'nl'),
                            (1044003576, 1044003591, 'nl'),
                            (1044003596, 1044003599, 'nl'),
                            (1044003616, 1044003631, 'nl'),
                            (1044003636, 1044003639, 'nl'),
                            (1044003648, 1044003651, 'nl'),
                            (1044003656, 1044003659, 'nl'),
                            (1044003664, 1044003667, 'nl'),
                            (1044003676, 1044003683, 'nl'),
                            (1044003688, 1044003691, 'nl'),
                            (1044003696, 1044003699, 'nl'),
                            (1044003724, 1044003727, 'nl'),
                            (1044003732, 1044003751, 'nl'),
                            (1044003756, 1044003775, 'nl'),
                            (1044003784, 1044003787, 'nl'),
                            (1044003796, 1044003799, 'nl'),
                            (1044003808, 1044003819, 'nl'),
                            (1044003824, 1044003831, 'nl'),
                            (1044003856, 1044003871, 'nl'),
                            (1044003880, 1044003895, 'nl'),
                            (1044003912, 1044003919, 'nl'),
                            (1044003928, 1044003959, 'nl'),
                            (1044003968, 1044003975, 'nl'),
                            (1044003984, 1044003991, 'nl'),
                            (1044004008, 1044004079, 'nl'),
                            (1044004096, 1044004303, 'nl'),
                            (1044004352, 1044004879, 'nl'),
                            (1044004904, 1044004911, 'nl'),
                            (1044004928, 1044005503, 'nl'),
                            (1044005632, 1044005647, 'nl'),
                            (1044005664, 1044005695, 'nl'),
                            (1044005800, 1044005807, 'nl'),
                            (1044005824, 1044005847, 'nl'),
                            (1044005888, 1044006143, 'nl'),
                            (1044006656, 1044006943, 'nl'),
                            (1044007008, 1044007023, 'nl'),
                            (1044007032, 1044007039, 'nl'),
                            (1044007048, 1044007055, 'nl'),
                            (1044007064, 1044007087, 'nl'),
                            (1044007120, 1044007135, 'nl'),
                            (1044007168, 1044007967, 'nl'),
                            (1044007984, 1044007991, 'nl'),
                            (1044008008, 1044008023, 'nl'),
                            (1044008032, 1044008039, 'nl'),
                            (1044008048, 1044008063, 'nl'),
                            (1044008096, 1044008127, 'nl'),
                            (1044008184, 1044008223, 'nl'),
                            (1044008240, 1044008255, 'nl'),
                            (1044008280, 1044008287, 'nl'),
                            (1044008320, 1044008735, 'nl'),
                            (1044009056, 1044009087, 'nl'),
                            (1044009184, 1044009199, 'nl'),
                            (1044009216, 1044009471, 'nl'),
                            (1044009488, 1044009503, 'nl'),
                            (1044009536, 1044009583, 'nl'),
                            (1044009600, 1044011223, 'nl'),
                            (1044011228, 1044011635, 'nl'),
                            (1044011640, 1044011703, 'nl'),
                            (1044011708, 1044011731, 'nl'),
                            (1044011736, 1044011771, 'nl'),
                            (1044011776, 1044011791, 'nl'),
                            (1044011796, 1044011971, 'nl'),
                            (1044012032, 1044012039, 'nl'),
                            (1044012048, 1044012087, 'nl'),
                            (1044012096, 1044012103, 'nl'),
                            (1044012112, 1044012119, 'nl'),
                            (1044012136, 1044012143, 'nl'),
                            (1044012152, 1044012159, 'nl'),
                            (1044012168, 1044012191, 'nl'),
                            (1044012208, 1044012239, 'nl'),
                            (1044012256, 1044013059, 'nl'),
                            (1044013112, 1044013119, 'nl'),
                            (1044013136, 1044013143, 'nl'),
                            (1044013248, 1044013263, 'nl'),
                            (1044013272, 1044013279, 'nl'),
                            (1044013376, 1044013439, 'nl'),
                            (1044013576, 1044013583, 'nl'),
                            (1044013616, 1044013623, 'nl'),
                            (1044014112, 1044014119, 'nl'),
                            (1044017168, 1044017187, 'nl'),
                            (1044017192, 1044017199, 'nl'),
                            (1044017216, 1044017247, 'nl'),
                            (1044017360, 1044017383, 'nl'),
                            (1044017400, 1044017407, 'nl'),
                            (1044017664, 1044017983, 'nl'),
                            (1044018040, 1044018047, 'nl'),
                            (1044018176, 1044019199, 'nl'),
                            (1044019280, 1044019283, 'nl'),
                            (1044019292, 1044019295, 'nl'),
                            (1044019316, 1044019323, 'nl'),
                            (1044019348, 1044019351, 'nl'),
                            (1044019384, 1044019399, 'nl'),
                            (1044019404, 1044019407, 'nl'),
                            (1044019416, 1044019439, 'nl'),
                            (1044019444, 1044019471, 'nl'),
                            (1044019492, 1044019495, 'nl'),
                            (1044019504, 1044019507, 'nl'),
                            (1044019696, 1044019699, 'nl'),
                            (1044019820, 1044019823, 'nl'),
                            (1044019996, 1044019999, 'nl'),
                            (1044020148, 1044020151, 'nl'),
                            (1044020216, 1044020219, 'nl'),
                            (1044020256, 1044020263, 'nl'),
                            (1044020304, 1044020319, 'nl'),
                            (1044020512, 1044020551, 'nl'),
                            (1044020568, 1044020591, 'nl'),
                            (1044020608, 1044020671, 'nl'),
                            (1044020736, 1044021759, 'nl'),
                            (1044021888, 1044022319, 'nl'),
                            (1044022336, 1044022359, 'nl'),
                            (1044022416, 1044023295, 'nl'),
                            (1044023312, 1044023319, 'nl'),
                            (1044023344, 1044023359, 'nl'),
                            (1044023408, 1044023439, 'nl'),
                            (1044024320, 1044024447, 'nl'),
                            (1044024576, 1044024835, 'nl'),
                            (1044024844, 1044024847, 'nl'),
                            (1044024852, 1044024855, 'nl'),
                            (1044024864, 1044024867, 'nl'),
                            (1044024876, 1044024883, 'nl'),
                            (1044024888, 1044024891, 'nl'),
                            (1044024960, 1044025351, 'nl'),
                            (1044025600, 1044026895, 'nl'),
                            (1044027264, 1044027423, 'nl'),
                            (1044027432, 1044027447, 'nl'),
                            (1044027456, 1044027471, 'nl'),
                            (1044027528, 1044027535, 'nl'),
                            (1044027576, 1044027583, 'nl'),
                            (1044027592, 1044027679, 'nl'),
                            (1044027704, 1044027727, 'nl'),
                            (1044027776, 1044027839, 'nl'),
                            (1044027904, 1044028159, 'nl'),
                            (1044028800, 1044028927, 'nl'),
                            (1044028940, 1044028947, 'nl'),
                            (1044028956, 1044028959, 'nl'),
                            (1044028992, 1044028995, 'nl'),
                            (1044029012, 1044029015, 'nl'),
                            (1044029020, 1044029023, 'nl'),
                            (1044029028, 1044029031, 'nl'),
                            (1044029036, 1044029043, 'nl'),
                            (1044029048, 1044029051, 'nl'),
                            (1044029056, 1044029059, 'nl'),
                            (1044029068, 1044029071, 'nl'),
                            (1044029312, 1044029441, 'nl'),
                            (1044029443, 1044029445, 'nl'),
                            (1044029449, 1044029451, 'nl'),
                            (1044029453, 1044029453, 'nl'),
                            (1044029456, 1044029463, 'nl'),
                            (1044029467, 1044029467, 'nl'),
                            (1044029471, 1044029479, 'nl'),
                            (1044029484, 1044029485, 'nl'),
                            (1044029488, 1044029488, 'nl'),
                            (1044029490, 1044029492, 'nl'),
                            (1044029494, 1044029494, 'nl'),
                            (1044029498, 1044029498, 'nl'),
                            (1044029502, 1044029502, 'nl'),
                            (1044029506, 1044029509, 'nl'),
                            (1044029511, 1044029511, 'nl'),
                            (1044029536, 1044029536, 'nl'),
                            (1044029538, 1044029538, 'nl'),
                            (1044029546, 1044029546, 'nl'),
                            (1044029549, 1044029549, 'nl'),
                            (1044029553, 1044029553, 'nl'),
                            (1044029555, 1044029556, 'nl'),
                            (1044029558, 1044029558, 'nl'),
                            (1044029562, 1044029567, 'nl'),
                            (1044029569, 1044029569, 'nl'),
                            (1044029573, 1044029575, 'nl'),
                            (1044029581, 1044029581, 'nl'),
                            (1044029585, 1044029585, 'nl'),
                            (1044029587, 1044029587, 'nl'),
                            (1044029591, 1044029595, 'nl'),
                            (1044029597, 1044029598, 'nl'),
                            (1044029600, 1044029600, 'nl'),
                            (1044029602, 1044029603, 'nl'),
                            (1044029607, 1044029608, 'nl'),
                            (1044029610, 1044029610, 'nl'),
                            (1044029612, 1044029612, 'nl'),
                            (1044029617, 1044029618, 'nl'),
                            (1044029621, 1044029622, 'nl'),
                            (1044029626, 1044029628, 'nl'),
                            (1044029631, 1044029631, 'nl'),
                            (1044029635, 1044029635, 'nl'),
                            (1044029637, 1044029638, 'nl'),
                            (1044029641, 1044029641, 'nl'),
                            (1044029643, 1044029647, 'nl'),
                            (1044029649, 1044029651, 'nl'),
                            (1044029653, 1044029659, 'nl'),
                            (1044029661, 1044029663, 'nl'),
                            (1044029666, 1044029667, 'nl'),
                            (1044029669, 1044029669, 'nl'),
                            (1044029673, 1044029676, 'nl'),
                            (1044029679, 1044029680, 'nl'),
                            (1044029682, 1044029682, 'nl'),
                            (1044029685, 1044029686, 'nl'),
                            (1044029688, 1044029693, 'nl'),
                            (1044029695, 1044029703, 'nl'),
                            (1044029712, 1044029719, 'nl'),
                            (1044029728, 1044029743, 'nl'),
                            (1044029768, 1044029775, 'nl'),
                            (1044029784, 1044029831, 'nl'),
                            (1044029840, 1044029871, 'nl'),
                            (1044029880, 1044029895, 'nl'),
                            (1044029920, 1044029951, 'nl'),
                            (1044029960, 1044029967, 'nl'),
                            (1044029984, 1044030015, 'nl'),
                            (1044030032, 1044030047, 'nl'),
                            (1044030056, 1044030063, 'nl'),
                            (1044030072, 1044030111, 'nl'),
                            (1044030120, 1044030127, 'nl'),
                            (1044030136, 1044030207, 'nl'),
                            (1044030224, 1044030231, 'nl'),
                            (1044030240, 1044030247, 'nl'),
                            (1044030264, 1044030279, 'nl'),
                            (1044030296, 1044030303, 'nl'),
                            (1044030312, 1044030335, 'nl'),
                            (1044030344, 1044030375, 'nl'),
                            (1044030392, 1044030399, 'nl'),
                            (1044030408, 1044030439, 'nl'),
                            (1044030448, 1044030463, 'nl'),
                            (1044030472, 1044030487, 'nl'),
                            (1044030496, 1044030527, 'nl'),
                            (1044030536, 1044030583, 'nl'),
                            (1044030592, 1044030607, 'nl'),
                            (1044030616, 1044030639, 'nl'),
                            (1044030648, 1044030671, 'nl'),
                            (1044030680, 1044030711, 'nl'),
                            (1044030720, 1044030727, 'nl'),
                            (1044030736, 1044030759, 'nl'),
                            (1044030768, 1044030815, 'nl'),
                            (1044030824, 1044030831, 'nl'),
                            (1044030848, 1044030879, 'nl'),
                            (1044030888, 1044030911, 'nl'),
                            (1044030920, 1044030927, 'nl'),
                            (1044030936, 1044030959, 'nl'),
                            (1044030968, 1044030999, 'nl'),
                            (1044031008, 1044031039, 'nl'),
                            (1044031104, 1044031119, 'nl'),
                            (1044031128, 1044031151, 'nl'),
                            (1044031168, 1044031271, 'nl'),
                            (1044031280, 1044031287, 'nl'),
                            (1044031296, 1044031319, 'nl'),
                            (1044031328, 1044031343, 'nl'),
                            (1044031352, 1044031359, 'nl'),
                            (1044031361, 1044031363, 'nl'),
                            (1044031365, 1044031367, 'nl'),
                            (1044031376, 1044031399, 'nl'),
                            (1044031432, 1044031439, 'nl'),
                            (1044031456, 1044031489, 'nl'),
                            (1044031491, 1044031494, 'nl'),
                            (1044031496, 1044031496, 'nl'),
                            (1044031498, 1044031507, 'nl'),
                            (1044031509, 1044031509, 'nl'),
                            (1044031511, 1044031519, 'nl'),
                            (1044031521, 1044031523, 'nl'),
                            (1044031525, 1044031531, 'nl'),
                            (1044031533, 1044031533, 'nl'),
                            (1044031537, 1044031550, 'nl'),
                            (1044031552, 1044031552, 'nl'),
                            (1044031554, 1044031556, 'nl'),
                            (1044031558, 1044031558, 'nl'),
                            (1044031560, 1044031562, 'nl'),
                            (1044031564, 1044031566, 'nl'),
                            (1044031568, 1044031568, 'nl'),
                            (1044031570, 1044031571, 'nl'),
                            (1044031573, 1044031573, 'nl'),
                            (1044031575, 1044031579, 'nl'),
                            (1044031582, 1044031582, 'nl'),
                            (1044031585, 1044031592, 'nl'),
                            (1044031594, 1044031597, 'nl'),
                            (1044031599, 1044031599, 'nl'),
                            (1044031601, 1044031627, 'nl'),
                            (1044031629, 1044031629, 'nl'),
                            (1044031631, 1044031635, 'nl'),
                            (1044031637, 1044031640, 'nl'),
                            (1044031642, 1044031643, 'nl'),
                            (1044031645, 1044031651, 'nl'),
                            (1044031653, 1044031654, 'nl'),
                            (1044031656, 1044031656, 'nl'),
                            (1044031659, 1044031666, 'nl'),
                            (1044031668, 1044031668, 'nl'),
                            (1044031671, 1044031673, 'nl'),
                            (1044031675, 1044031675, 'nl'),
                            (1044031678, 1044031683, 'nl'),
                            (1044031685, 1044031687, 'nl'),
                            (1044031689, 1044031690, 'nl'),
                            (1044031693, 1044031698, 'nl'),
                            (1044031700, 1044031702, 'nl'),
                            (1044031705, 1044031709, 'nl'),
                            (1044031711, 1044031711, 'nl'),
                            (1044031713, 1044031714, 'nl'),
                            (1044031716, 1044031717, 'nl'),
                            (1044031720, 1044031721, 'nl'),
                            (1044031724, 1044031726, 'nl'),
                            (1044031728, 1044031751, 'nl'),
                            (1044031760, 1044031799, 'nl'),
                            (1044031808, 1044031815, 'nl'),
                            (1044031872, 1044031879, 'nl'),
                            (1044031888, 1044031927, 'nl'),
                            (1044031936, 1044031951, 'nl'),
                            (1044031992, 1044031999, 'nl'),
                            (1044032032, 1044032047, 'nl'),
                            (1044032056, 1044032071, 'nl'),
                            (1044032080, 1044032103, 'nl'),
                            (1044032128, 1044032151, 'nl'),
                            (1044032168, 1044032175, 'nl'),
                            (1044032184, 1044032191, 'nl'),
                            (1044032200, 1044032223, 'nl'),
                            (1044032240, 1044032263, 'nl'),
                            (1044032288, 1044032303, 'nl'),
                            (1044032328, 1044032375, 'nl'),
                            (1044032408, 1044032471, 'nl'),
                            (1044032480, 1044032527, 'nl'),
                            (1044032560, 1044032583, 'nl'),
                            (1044032616, 1044032639, 'nl'),
                            (1044032648, 1044032695, 'nl'),
                            (1044032704, 1044032719, 'nl'),
                            (1044032728, 1044032735, 'nl'),
                            (1044032744, 1044032775, 'nl'),
                            (1044032784, 1044032791, 'nl'),
                            (1044032800, 1044032815, 'nl'),
                            (1044032832, 1044032855, 'nl'),
                            (1044032864, 1044032887, 'nl'),
                            (1044032904, 1044032927, 'nl'),
                            (1044032936, 1044032951, 'nl'),
                            (1044032960, 1044032967, 'nl'),
                            (1044032976, 1044032991, 'nl'),
                            (1044033000, 1044033031, 'nl'),
                            (1044033056, 1044033071, 'nl'),
                            (1044033080, 1044033111, 'nl'),
                            (1044033120, 1044033135, 'nl'),
                            (1044033160, 1044033207, 'nl'),
                            (1044033216, 1044033223, 'nl'),
                            (1044033232, 1044033335, 'nl'),
                            (1044033344, 1044033351, 'nl'),
                            (1044033360, 1044033375, 'nl'),
                            (1044033408, 1044033431, 'nl'),
                            (1044033448, 1044033527, 'nl'),
                            (1044033536, 1044033543, 'nl'),
                            (1044033552, 1044033575, 'nl'),
                            (1044033584, 1044033623, 'nl'),
                            (1044033632, 1044033655, 'nl'),
                            (1044033664, 1044033671, 'nl'),
                            (1044033688, 1044033719, 'nl'),
                            (1044033728, 1044033895, 'nl'),
                            (1044033904, 1044033927, 'nl'),
                            (1044033936, 1044033991, 'nl'),
                            (1044034000, 1044034015, 'nl'),
                            (1044034024, 1044034031, 'nl'),
                            (1044034040, 1044034095, 'nl'),
                            (1044034120, 1044034127, 'nl'),
                            (1044034136, 1044034207, 'nl'),
                            (1044034216, 1044034231, 'nl'),
                            (1044034240, 1044034263, 'nl'),
                            (1044034272, 1044034279, 'nl'),
                            (1044034296, 1044034303, 'nl'),
                            (1044034312, 1044034327, 'nl'),
                            (1044034336, 1044034375, 'nl'),
                            (1044034384, 1044034487, 'nl'),
                            (1044034496, 1044034511, 'nl'),
                            (1044034520, 1044034615, 'nl'),
                            (1044034624, 1044034663, 'nl'),
                            (1044034672, 1044034735, 'nl'),
                            (1044034744, 1044034751, 'nl'),
                            (1044034760, 1044034783, 'nl'),
                            (1044034792, 1044034847, 'nl'),
                            (1044034856, 1044034975, 'nl'),
                            (1044034984, 1044034999, 'nl'),
                            (1044035008, 1044035031, 'nl'),
                            (1044035040, 1044035047, 'nl'),
                            (1044035056, 1044035063, 'nl'),
                            (1044035072, 1044035143, 'nl'),
                            (1044035152, 1044035191, 'nl'),
                            (1044035200, 1044035255, 'nl'),
                            (1044035264, 1044035287, 'nl'),
                            (1044035312, 1044035327, 'nl'),
                            (1044035352, 1044035415, 'nl'),
                            (1044035424, 1044035447, 'nl'),
                            (1044035472, 1044035479, 'nl'),
                            (1044035488, 1044035495, 'nl'),
                            (1044035504, 1044035511, 'nl'),
                            (1044035528, 1044035559, 'nl'),
                            (1044035592, 1044035607, 'nl'),
                            (1044035624, 1044035655, 'nl'),
                            (1044035664, 1044035671, 'nl'),
                            (1044035680, 1044035711, 'nl'),
                            (1044035728, 1044035751, 'nl'),
                            (1044035760, 1044035791, 'nl'),
                            (1044035808, 1044035831, 'nl'),
                            (1044035840, 1044035847, 'nl'),
                            (1044035872, 1044035887, 'nl'),
                            (1044035896, 1044035903, 'nl'),
                            (1044035920, 1044035943, 'nl'),
                            (1044035968, 1044035975, 'nl'),
                            (1044035984, 1044035999, 'nl'),
                            (1044036008, 1044036039, 'nl'),
                            (1044036048, 1044036079, 'nl'),
                            (1044036088, 1044036095, 'nl'),
                            (1044036104, 1044036111, 'nl'),
                            (1044036120, 1044036127, 'nl'),
                            (1044036136, 1044036143, 'nl'),
                            (1044036160, 1044036175, 'nl'),
                            (1044036200, 1044036231, 'nl'),
                            (1044036240, 1044036255, 'nl'),
                            (1044036272, 1044036295, 'nl'),
                            (1044036312, 1044036327, 'nl'),
                            (1044036336, 1044036399, 'nl'),
                            (1044036408, 1044036471, 'nl'),
                            (1044036480, 1044036503, 'nl'),
                            (1044036512, 1044036535, 'nl'),
                            (1044036544, 1044036559, 'nl'),
                            (1044036568, 1044036575, 'nl'),
                            (1044036608, 1044036615, 'nl'),
                            (1044036624, 1044036647, 'nl'),
                            (1044036656, 1044036671, 'nl'),
                            (1044036688, 1044036759, 'nl'),
                            (1044036768, 1044036775, 'nl'),
                            (1044036784, 1044036791, 'nl'),
                            (1044036800, 1044036807, 'nl'),
                            (1044036816, 1044036863, 'nl'),
                            (1044036865, 1044036865, 'nl'),
                            (1044036867, 1044036890, 'nl'),
                            (1044036892, 1044036899, 'nl'),
                            (1044036901, 1044036907, 'nl'),
                            (1044036909, 1044036909, 'nl'),
                            (1044036911, 1044036927, 'nl'),
                            (1044036929, 1044036942, 'nl'),
                            (1044036944, 1044036948, 'nl'),
                            (1044036952, 1044036957, 'nl'),
                            (1044036959, 1044036967, 'nl'),
                            (1044036969, 1044036970, 'nl'),
                            (1044036972, 1044036976, 'nl'),
                            (1044036978, 1044036984, 'nl'),
                            (1044036986, 1044036990, 'nl'),
                            (1044036992, 1044037007, 'nl'),
                            (1044037011, 1044037014, 'nl'),
                            (1044037016, 1044037021, 'nl'),
                            (1044037023, 1044037023, 'nl'),
                            (1044037026, 1044037026, 'nl'),
                            (1044037028, 1044037037, 'nl'),
                            (1044037039, 1044037042, 'nl'),
                            (1044037044, 1044037047, 'nl'),
                            (1044037049, 1044037049, 'nl'),
                            (1044037052, 1044037056, 'nl'),
                            (1044037058, 1044037061, 'nl'),
                            (1044037064, 1044037065, 'nl'),
                            (1044037067, 1044037070, 'nl'),
                            (1044037072, 1044037074, 'nl'),
                            (1044037076, 1044037091, 'nl'),
                            (1044037093, 1044037098, 'nl'),
                            (1044037101, 1044037101, 'nl'),
                            (1044037103, 1044037106, 'nl'),
                            (1044037108, 1044037109, 'nl'),
                            (1044037111, 1044037143, 'nl'),
                            (1044037152, 1044037159, 'nl'),
                            (1044037168, 1044037191, 'nl'),
                            (1044037200, 1044037207, 'nl'),
                            (1044037224, 1044037271, 'nl'),
                            (1044037280, 1044037287, 'nl'),
                            (1044037296, 1044037667, 'nl'),
                            (1044037680, 1044037703, 'nl'),
                            (1044037712, 1044037735, 'nl'),
                            (1044037744, 1044037767, 'nl'),
                            (1044037784, 1044037791, 'nl'),
                            (1044037824, 1044037831, 'nl'),
                            (1044037840, 1044037855, 'nl'),
                            (1044037888, 1044038143, 'nl'),
                            (1044038528, 1044038535, 'nl'),
                            (1044038544, 1044038559, 'nl'),
                            (1044038568, 1044038591, 'nl'),
                            (1044038600, 1044038615, 'nl'),
                            (1044038624, 1044038639, 'nl'),
                            (1044038648, 1044038783, 'nl'),
                            (1044038912, 1044038919, 'nl'),
                            (1044038928, 1044038935, 'nl'),
                            (1044038944, 1044039751, 'nl'),
                            (1044039760, 1044039775, 'nl'),
                            (1044039856, 1044039999, 'nl'),
                            (1044040016, 1044040063, 'nl'),
                            (1044040096, 1044040103, 'nl'),
                            (1044040112, 1044040231, 'nl'),
                            (1044040240, 1044040255, 'nl'),
                            (1044040704, 1044041727, 'nl'),
                            (1044043776, 1044043783, 'nl'),
                            (1044043788, 1044043791, 'nl'),
                            (1044043796, 1044043799, 'nl'),
                            (1044043804, 1044043807, 'nl'),
                            (1044043812, 1044043823, 'nl'),
                            (1044043828, 1044043835, 'nl'),
                            (1044043848, 1044043851, 'nl'),
                            (1044043880, 1044043883, 'nl'),
                            (1044043896, 1044043903, 'nl'),
                            (1044043908, 1044043919, 'nl'),
                            (1044043928, 1044043931, 'nl'),
                            (1044043936, 1044043943, 'nl'),
                            (1044043956, 1044043971, 'nl'),
                            (1044043976, 1044043987, 'nl'),
                            (1044044000, 1044044003, 'nl'),
                            (1044044008, 1044044011, 'nl'),
                            (1044044016, 1044044019, 'nl'),
                            (1044044028, 1044044035, 'nl'),
                            (1044044044, 1044044051, 'nl'),
                            (1044044056, 1044044059, 'nl'),
                            (1044044072, 1044044083, 'nl'),
                            (1044044096, 1044044119, 'nl'),
                            (1044044132, 1044044135, 'nl'),
                            (1044044144, 1044044163, 'nl'),
                            (1044044168, 1044044171, 'nl'),
                            (1044044188, 1044044215, 'nl'),
                            (1044044224, 1044044243, 'nl'),
                            (1044044248, 1044044251, 'nl'),
                            (1044045312, 1044045695, 'nl'),
                            (1044045912, 1044045919, 'nl'),
                            (1044046080, 1044046223, 'nl'),
                            (1044046232, 1044046239, 'nl'),
                            (1044046320, 1044046327, 'nl'),
                            (1044046848, 1044051967, 'nl'),
                            (1044051988, 1044051991, 'nl'),
                            (1044052012, 1044052015, 'nl'),
                            (1044052032, 1044052039, 'nl'),
                            (1044052064, 1044052067, 'nl'),
                            (1044052108, 1044052111, 'nl'),
                            (1044052132, 1044052135, 'nl'),
                            (1044052224, 1044052227, 'nl'),
                            (1044052256, 1044052259, 'nl'),
                            (1044052348, 1044052359, 'nl'),
                            (1044052364, 1044052375, 'nl'),
                            (1044052480, 1044052483, 'nl'),
                            (1044052968, 1044052971, 'nl'),
                            (1044052984, 1044052987, 'nl'),
                            (1044053056, 1044053063, 'nl'),
                            (1044053256, 1044053263, 'nl'),
                            (1044053456, 1044053463, 'nl'),
                            (1044053504, 1044059263, 'nl'),
                            (1044059936, 1044060031, 'nl'),
                            (1044060064, 1044061191, 'nl'),
                            (1044061224, 1044061263, 'nl'),
                            (1044061272, 1044061391, 'nl'),
                            (1044061400, 1044061431, 'nl'),
                            (1044061440, 1044061759, 'nl'),
                            (1044061776, 1044061783, 'nl'),
                            (1044061800, 1044061831, 'nl'),
                            (1044061840, 1044061879, 'nl'),
                            (1044061896, 1044061919, 'nl'),
                            (1044061952, 1044062015, 'nl'),
                            (1044062048, 1044062079, 'nl'),
                            (1044062088, 1044062103, 'nl'),
                            (1044062120, 1044062127, 'nl'),
                            (1044062136, 1044062175, 'nl'),
                            (1044062200, 1044062223, 'nl'),
                            (1044062240, 1044062375, 'nl'),
                            (1044062384, 1044062399, 'nl'),
                            (1044062416, 1044062455, 'nl'),
                            (1044062472, 1044062503, 'nl'),
                            (1044062528, 1044062535, 'nl'),
                            (1044062544, 1044062575, 'nl'),
                            (1044062584, 1044062591, 'nl'),
                            (1044062600, 1044062607, 'nl'),
                            (1044062624, 1044062647, 'nl'),
                            (1044062656, 1044062663, 'nl'),
                            (1044062672, 1044063231, 'nl'),
                            (1044063356, 1044063363, 'nl'),
                            (1044067328, 1044068351, 'nl'),
                            (1044068992, 1044069631, 'nl'),
                            (1044070400, 1044076607, 'nl'),
                            (1044076800, 1044077823, 'nl'),
                            (1044078592, 1044092927, 'nl'),
                            (1044093184, 1044103263, 'nl'),
                            (1044103424, 1044103999, 'nl'),
                            (1044104032, 1044104287, 'nl'),
                            (1044104320, 1044104367, 'nl'),
                            (1044104384, 1044104543, 'nl'),
                            (1044104560, 1044104831, 'nl'),
                            (1044105024, 1044105151, 'nl'),
                            (1044106772, 1044106775, 'nl'),
                            (1044106788, 1044106795, 'nl'),
                            (1044106808, 1044106815, 'nl'),
                            (1044107264, 1044117503, 'nl'),
                            (1044117552, 1044117567, 'nl'),
                            (1044118528, 1044119551, 'nl'),
                            (1044750336, 1044758527, 'nl'),
                            (1044955136, 1044963327, 'nl'),
                            (1045460736, 1045460991, 'nl'),
                            (1045461736, 1045461743, 'nl'),
                            (1046317824, 1046318335, 'nl'),
                            (1046318592, 1046320127, 'nl'),
                            (1046321152, 1046323199, 'nl'),
                            (1046331904, 1046332159, 'nl'),
                            (1046340096, 1046341119, 'nl'),
                            (1046342144, 1046342719, 'nl'),
                            (1046343424, 1046343935, 'nl'),
                            (1046740992, 1046757375, 'nl'),
                            (1047117824, 1047134207, 'nl'),
                            (1047265280, 1047273471, 'nl'),
                            (1047379968, 1047396351, 'nl'),
                            (1047563452, 1047563455, 'nl'),
                            (1047567104, 1047567111, 'nl'),
                            (1047568384, 1047576575, 'nl'),
                            (1047584768, 1047592959, 'nl'),
                            (1048674304, 1048682495, 'nl'),
                            (1048772608, 1048838143, 'nl'),
                            (1048838208, 1048838239, 'nl'),
                            (1048839936, 1048839983, 'nl'),
                            (1048839992, 1048840095, 'nl'),
                            (1048840104, 1048840135, 'nl'),
                            (1048840144, 1048840151, 'nl'),
                            (1048840160, 1048840271, 'nl'),
                            (1048840280, 1048840295, 'nl'),
                            (1048840304, 1048840463, 'nl'),
                            (1048840480, 1048840503, 'nl'),
                            (1048840512, 1048840631, 'nl'),
                            (1048840640, 1048840679, 'nl'),
                            (1048840688, 1048840703, 'nl'),
                            (1048843264, 1048843303, 'nl'),
                            (1048843312, 1048843327, 'nl'),
                            (1048843336, 1048843407, 'nl'),
                            (1048843416, 1048843447, 'nl'),
                            (1048843456, 1048843471, 'nl'),
                            (1048843480, 1048843527, 'nl'),
                            (1048843536, 1048843559, 'nl'),
                            (1048843568, 1048843687, 'nl'),
                            (1048843696, 1048843703, 'nl'),
                            (1048843712, 1048843847, 'nl'),
                            (1048843856, 1048843927, 'nl'),
                            (1048843936, 1048843983, 'nl'),
                            (1048843992, 1048844087, 'nl'),
                            (1048844096, 1048844287, 'nl'),
                            (1048844320, 1048844351, 'nl'),
                            (1048845568, 1048845575, 'nl'),
                            (1048845584, 1048845743, 'nl'),
                            (1048845752, 1048845759, 'nl'),
                            (1048845768, 1048845775, 'nl'),
                            (1048845784, 1048845855, 'nl'),
                            (1048845864, 1048845935, 'nl'),
                            (1048845944, 1048846031, 'nl'),
                            (1048846040, 1048846439, 'nl'),
                            (1048846448, 1048846495, 'nl'),
                            (1048846504, 1048846551, 'nl'),
                            (1048846560, 1048846647, 'nl'),
                            (1048846656, 1048846703, 'nl'),
                            (1048846712, 1048846775, 'nl'),
                            (1048846784, 1048846791, 'nl'),
                            (1048846800, 1048846847, 'nl'),
                            (1048847360, 1048847407, 'nl'),
                            (1048847416, 1048847775, 'nl'),
                            (1048847784, 1048847871, 'nl'),
                            (1048847880, 1048847919, 'nl'),
                            (1048847928, 1048848071, 'nl'),
                            (1048848080, 1048848191, 'nl'),
                            (1048848200, 1048848263, 'nl'),
                            (1048848272, 1048848311, 'nl'),
                            (1048848320, 1048848399, 'nl'),
                            (1048848408, 1048848679, 'nl'),
                            (1048848688, 1048848895, 'nl'),
                            (1048849408, 1048849615, 'nl'),
                            (1048849624, 1048849639, 'nl'),
                            (1048849648, 1048849679, 'nl'),
                            (1048849688, 1048849919, 'nl'),
                            (1048849928, 1048849975, 'nl'),
                            (1048849984, 1048849991, 'nl'),
                            (1048850000, 1048850311, 'nl'),
                            (1048850320, 1048850359, 'nl'),
                            (1048850368, 1048850599, 'nl'),
                            (1048850608, 1048850615, 'nl'),
                            (1048850632, 1048850855, 'nl'),
                            (1048850864, 1048850887, 'nl'),
                            (1048850896, 1048851167, 'nl'),
                            (1048851176, 1048851223, 'nl'),
                            (1048851232, 1048851303, 'nl'),
                            (1048851312, 1048851319, 'nl'),
                            (1048851328, 1048851399, 'nl'),
                            (1048851408, 1048851455, 'nl'),
                            (1048851464, 1048851495, 'nl'),
                            (1048851504, 1048851719, 'nl'),
                            (1048851728, 1048851743, 'nl'),
                            (1048851752, 1048851767, 'nl'),
                            (1048851776, 1048852039, 'nl'),
                            (1048852048, 1048852087, 'nl'),
                            (1048852096, 1048852103, 'nl'),
                            (1048852112, 1048852135, 'nl'),
                            (1048852144, 1048852439, 'nl'),
                            (1048852448, 1048852719, 'nl'),
                            (1048852728, 1048852911, 'nl'),
                            (1048852920, 1048852991, 'nl'),
                            (1048853000, 1048853231, 'nl'),
                            (1048853240, 1048853343, 'nl'),
                            (1048853352, 1048853367, 'nl'),
                            (1048853376, 1048853503, 'nl'),
                            (1048853512, 1048853527, 'nl'),
                            (1048853536, 1048853679, 'nl'),
                            (1048853688, 1048853783, 'nl'),
                            (1048853792, 1048854007, 'nl'),
                            (1048854016, 1048854039, 'nl'),
                            (1048854048, 1048854055, 'nl'),
                            (1048854064, 1048854167, 'nl'),
                            (1048854176, 1048854255, 'nl'),
                            (1048854264, 1048854319, 'nl'),
                            (1048854344, 1048854527, 'nl'),
                            (1048855040, 1048855159, 'nl'),
                            (1048855168, 1048855319, 'nl'),
                            (1048855328, 1048855351, 'nl'),
                            (1048855360, 1048855367, 'nl'),
                            (1048855384, 1048855503, 'nl'),
                            (1048855512, 1048855543, 'nl'),
                            (1048855560, 1048855695, 'nl'),
                            (1048855704, 1048855719, 'nl'),
                            (1048855728, 1048855743, 'nl'),
                            (1048855752, 1048855759, 'nl'),
                            (1048855776, 1048856079, 'nl'),
                            (1048856088, 1048856095, 'nl'),
                            (1048856104, 1048856359, 'nl'),
                            (1048856368, 1048856375, 'nl'),
                            (1048856384, 1048856415, 'nl'),
                            (1048856432, 1048856455, 'nl'),
                            (1048856464, 1048856503, 'nl'),
                            (1048856512, 1048856719, 'nl'),
                            (1048856728, 1048856815, 'nl'),
                            (1048856824, 1048857023, 'nl'),
                            (1048857032, 1048857039, 'nl'),
                            (1048857048, 1048857103, 'nl'),
                            (1048857112, 1048857199, 'nl'),
                            (1048857208, 1048857503, 'nl'),
                            (1048857512, 1048857799, 'nl'),
                            (1048857816, 1048857903, 'nl'),
                            (1048857912, 1048858047, 'nl'),
                            (1048858056, 1048858111, 'nl'),
                            (1048858624, 1048858727, 'nl'),
                            (1048858736, 1048858751, 'nl'),
                            (1048858768, 1048858799, 'nl'),
                            (1048858816, 1048858863, 'nl'),
                            (1048858872, 1048858935, 'nl'),
                            (1048858944, 1048858967, 'nl'),
                            (1048858984, 1048859047, 'nl'),
                            (1048859056, 1048859063, 'nl'),
                            (1048859072, 1048859111, 'nl'),
                            (1048859120, 1048859335, 'nl'),
                            (1048859344, 1048859351, 'nl'),
                            (1048859360, 1048859375, 'nl'),
                            (1048859392, 1048859575, 'nl'),
                            (1048859584, 1048859655, 'nl'),
                            (1048859664, 1048859687, 'nl'),
                            (1048859696, 1048859895, 'nl'),
                            (1048859904, 1048860303, 'nl'),
                            (1048860320, 1048860327, 'nl'),
                            (1048860336, 1048860407, 'nl'),
                            (1048860424, 1048860495, 'nl'),
                            (1048860504, 1048860591, 'nl'),
                            (1048860600, 1048860847, 'nl'),
                            (1048860856, 1048860927, 'nl'),
                            (1048860944, 1048860983, 'nl'),
                            (1048860992, 1048861015, 'nl'),
                            (1048861024, 1048861119, 'nl'),
                            (1048861128, 1048861255, 'nl'),
                            (1048861264, 1048861391, 'nl'),
                            (1048861400, 1048861415, 'nl'),
                            (1048861424, 1048861455, 'nl'),
                            (1048861464, 1048861487, 'nl'),
                            (1048861496, 1048861535, 'nl'),
                            (1048861544, 1048861735, 'nl'),
                            (1048861752, 1048861783, 'nl'),
                            (1048861792, 1048861879, 'nl'),
                            (1048861888, 1048861983, 'nl'),
                            (1048861992, 1048862039, 'nl'),
                            (1048862048, 1048862135, 'nl'),
                            (1048862144, 1048862215, 'nl'),
                            (1048862224, 1048862311, 'nl'),
                            (1048862320, 1048862423, 'nl'),
                            (1048862432, 1048862495, 'nl'),
                            (1048862512, 1048862671, 'nl'),
                            (1048862680, 1048862711, 'nl'),
                            (1048862720, 1048862727, 'nl'),
                            (1048862736, 1048862775, 'nl'),
                            (1048862784, 1048862967, 'nl'),
                            (1048862976, 1048863119, 'nl'),
                            (1048863128, 1048863191, 'nl'),
                            (1048863200, 1048863495, 'nl'),
                            (1048863504, 1048863543, 'nl'),
                            (1048863552, 1048863583, 'nl'),
                            (1048863592, 1048863631, 'nl'),
                            (1048863648, 1048863711, 'nl'),
                            (1048863720, 1048863743, 'nl'),
                            (1048863752, 1048864023, 'nl'),
                            (1048864032, 1048864103, 'nl'),
                            (1048864112, 1048864159, 'nl'),
                            (1048864168, 1048864215, 'nl'),
                            (1048864224, 1048864439, 'nl'),
                            (1048864448, 1048864607, 'nl'),
                            (1048864616, 1048864871, 'nl'),
                            (1048864880, 1048865007, 'nl'),
                            (1048865016, 1048865087, 'nl'),
                            (1048865096, 1048865111, 'nl'),
                            (1048865120, 1048865279, 'nl'),
                            (1048865792, 1048865927, 'nl'),
                            (1048865936, 1048866039, 'nl'),
                            (1048866048, 1048866119, 'nl'),
                            (1048866128, 1048866295, 'nl'),
                            (1048866304, 1048866503, 'nl'),
                            (1048866512, 1048866535, 'nl'),
                            (1048866544, 1048866607, 'nl'),
                            (1048866616, 1048866823, 'nl'),
                            (1048866832, 1048866943, 'nl'),
                            (1048866952, 1048866983, 'nl'),
                            (1048866992, 1048867039, 'nl'),
                            (1048867048, 1048867255, 'nl'),
                            (1048867264, 1048867327, 'nl'),
                            (1048868352, 1048868703, 'nl'),
                            (1048868712, 1048868775, 'nl'),
                            (1048868784, 1048868903, 'nl'),
                            (1048868912, 1048868951, 'nl'),
                            (1048868960, 1048869031, 'nl'),
                            (1048869040, 1048869079, 'nl'),
                            (1048869088, 1048869095, 'nl'),
                            (1048869104, 1048869167, 'nl'),
                            (1048869176, 1048869239, 'nl'),
                            (1048869248, 1048869287, 'nl'),
                            (1048869296, 1048869375, 'nl'),
                            (1048869384, 1048869495, 'nl'),
                            (1048869504, 1048869511, 'nl'),
                            (1048869520, 1048869583, 'nl'),
                            (1048869592, 1048869679, 'nl'),
                            (1048869688, 1048869727, 'nl'),
                            (1048869736, 1048870111, 'nl'),
                            (1048870128, 1048870399, 'nl'),
                            (1048870912, 1048871063, 'nl'),
                            (1048871072, 1048871135, 'nl'),
                            (1048871144, 1048871279, 'nl'),
                            (1048871288, 1048871631, 'nl'),
                            (1048871640, 1048871647, 'nl'),
                            (1048871656, 1048871727, 'nl'),
                            (1048871736, 1048871935, 'nl'),
                            (1048872704, 1048872767, 'nl'),
                            (1048872776, 1048872823, 'nl'),
                            (1048872832, 1048873079, 'nl'),
                            (1048873088, 1048873127, 'nl'),
                            (1048873136, 1048873143, 'nl'),
                            (1048873152, 1048873239, 'nl'),
                            (1048873248, 1048873263, 'nl'),
                            (1048873272, 1048873367, 'nl'),
                            (1048873376, 1048873423, 'nl'),
                            (1048873432, 1048873447, 'nl'),
                            (1048873456, 1048873495, 'nl'),
                            (1048873504, 1048873727, 'nl'),
                            (1048873736, 1048873887, 'nl'),
                            (1048873896, 1048873919, 'nl'),
                            (1048873928, 1048874023, 'nl'),
                            (1048874032, 1048874063, 'nl'),
                            (1048874072, 1048874207, 'nl'),
                            (1048874216, 1048874231, 'nl'),
                            (1048874248, 1048874383, 'nl'),
                            (1048874392, 1048874407, 'nl'),
                            (1048874416, 1048874487, 'nl'),
                            (1048874504, 1048874607, 'nl'),
                            (1048874616, 1048874623, 'nl'),
                            (1048874632, 1048874671, 'nl'),
                            (1048874688, 1048874711, 'nl'),
                            (1048874720, 1048874919, 'nl'),
                            (1048874928, 1048874975, 'nl'),
                            (1048875000, 1048875007, 'nl'),
                            (1048875016, 1048875055, 'nl'),
                            (1048875064, 1048875095, 'nl'),
                            (1048875104, 1048875119, 'nl'),
                            (1048875128, 1048875159, 'nl'),
                            (1048875168, 1048875239, 'nl'),
                            (1048875248, 1048875255, 'nl'),
                            (1048875264, 1048875311, 'nl'),
                            (1048875320, 1048875359, 'nl'),
                            (1048875368, 1048875375, 'nl'),
                            (1048875384, 1048875463, 'nl'),
                            (1048875472, 1048875479, 'nl'),
                            (1048875496, 1048875535, 'nl'),
                            (1048875544, 1048875575, 'nl'),
                            (1048875592, 1048875719, 'nl'),
                            (1048875728, 1048875799, 'nl'),
                            (1048875808, 1048875855, 'nl'),
                            (1048875864, 1048875879, 'nl'),
                            (1048875888, 1048875983, 'nl'),
                            (1048875992, 1048875999, 'nl'),
                            (1048876024, 1048876127, 'nl'),
                            (1048876136, 1048876327, 'nl'),
                            (1048876336, 1048876519, 'nl'),
                            (1048876528, 1048876599, 'nl'),
                            (1048876608, 1048876735, 'nl'),
                            (1048876744, 1048876903, 'nl'),
                            (1048876912, 1048876967, 'nl'),
                            (1048876976, 1048877015, 'nl'),
                            (1048877024, 1048877311, 'nl'),
                            (1048878088, 1048878487, 'nl'),
                            (1048878496, 1048878543, 'nl'),
                            (1048878552, 1048878751, 'nl'),
                            (1048878760, 1048878983, 'nl'),
                            (1048878992, 1048879047, 'nl'),
                            (1048879056, 1048879263, 'nl'),
                            (1048879272, 1048879319, 'nl'),
                            (1048879328, 1048879375, 'nl'),
                            (1048879384, 1048879423, 'nl'),
                            (1048879432, 1048879447, 'nl'),
                            (1048879456, 1048879471, 'nl'),
                            (1048879480, 1048879527, 'nl'),
                            (1048879536, 1048879551, 'nl'),
                            (1048879568, 1048879663, 'nl'),
                            (1048879672, 1048879903, 'nl'),
                            (1048879912, 1048880071, 'nl'),
                            (1048880080, 1048880239, 'nl'),
                            (1048880248, 1048880303, 'nl'),
                            (1048880312, 1048880407, 'nl'),
                            (1048880416, 1048880639, 'nl'),
                            (1048881152, 1048881159, 'nl'),
                            (1048881168, 1048881231, 'nl'),
                            (1048881240, 1048881503, 'nl'),
                            (1048881512, 1048881535, 'nl'),
                            (1048881544, 1048881663, 'nl'),
                            (1048881672, 1048881783, 'nl'),
                            (1048881800, 1048881823, 'nl'),
                            (1048881832, 1048881935, 'nl'),
                            (1048881944, 1048881967, 'nl'),
                            (1048881992, 1048882087, 'nl'),
                            (1048882096, 1048882111, 'nl'),
                            (1048882120, 1048882127, 'nl'),
                            (1048882136, 1048882151, 'nl'),
                            (1048882160, 1048882327, 'nl'),
                            (1048882336, 1048882383, 'nl'),
                            (1048882392, 1048882487, 'nl'),
                            (1048882496, 1048882575, 'nl'),
                            (1048882592, 1048882647, 'nl'),
                            (1048882656, 1048882679, 'nl'),
                            (1048882696, 1048882727, 'nl'),
                            (1048882736, 1048882959, 'nl'),
                            (1048882968, 1048883095, 'nl'),
                            (1048883104, 1048883143, 'nl'),
                            (1048883152, 1048883263, 'nl'),
                            (1048883280, 1048883335, 'nl'),
                            (1048883344, 1048883511, 'nl'),
                            (1048883520, 1048883599, 'nl'),
                            (1048883608, 1048883695, 'nl'),
                            (1048883704, 1048883951, 'nl'),
                            (1048883960, 1048884167, 'nl'),
                            (1048884184, 1048884191, 'nl'),
                            (1048884200, 1048884279, 'nl'),
                            (1048884288, 1048884415, 'nl'),
                            (1048884424, 1048884447, 'nl'),
                            (1048884456, 1048884615, 'nl'),
                            (1048884624, 1048884655, 'nl'),
                            (1048884664, 1048884735, 'nl'),
                            (1048884744, 1048884775, 'nl'),
                            (1048884784, 1048884967, 'nl'),
                            (1048884976, 1048885023, 'nl'),
                            (1048885032, 1048885127, 'nl'),
                            (1048885144, 1048885271, 'nl'),
                            (1048885280, 1048885303, 'nl'),
                            (1048885312, 1048885319, 'nl'),
                            (1048885328, 1048885351, 'nl'),
                            (1048885360, 1048885471, 'nl'),
                            (1048885480, 1048885559, 'nl'),
                            (1048885568, 1048885591, 'nl'),
                            (1048885600, 1048885951, 'nl'),
                            (1048885960, 1048886079, 'nl'),
                            (1048886088, 1048886199, 'nl'),
                            (1048886208, 1048886383, 'nl'),
                            (1048886392, 1048886559, 'nl'),
                            (1048886576, 1048886607, 'nl'),
                            (1048886616, 1048886631, 'nl'),
                            (1048886640, 1048886687, 'nl'),
                            (1048886696, 1048886727, 'nl'),
                            (1048886736, 1048886855, 'nl'),
                            (1048886864, 1048886927, 'nl'),
                            (1048886936, 1048886983, 'nl'),
                            (1048886992, 1048886999, 'nl'),
                            (1048887008, 1048887167, 'nl'),
                            (1048887176, 1048887935, 'nl'),
                            (1048888000, 1048891167, 'nl'),
                            (1048891176, 1048891351, 'nl'),
                            (1048891360, 1048891559, 'nl'),
                            (1048891568, 1048891599, 'nl'),
                            (1048891608, 1048891623, 'nl'),
                            (1048891632, 1048891655, 'nl'),
                            (1048891672, 1048891695, 'nl'),
                            (1048891704, 1048891711, 'nl'),
                            (1048891720, 1048891823, 'nl'),
                            (1048891832, 1048891911, 'nl'),
                            (1048891920, 1048892311, 'nl'),
                            (1048892320, 1048892343, 'nl'),
                            (1048892352, 1048892815, 'nl'),
                            (1048892824, 1048892863, 'nl'),
                            (1048892872, 1048892895, 'nl'),
                            (1048892904, 1048893279, 'nl'),
                            (1048893288, 1048894039, 'nl'),
                            (1048894048, 1048894071, 'nl'),
                            (1048894080, 1048894215, 'nl'),
                            (1048894224, 1048894471, 'nl'),
                            (1048894480, 1048894607, 'nl'),
                            (1048894616, 1048894671, 'nl'),
                            (1048894680, 1048894735, 'nl'),
                            (1048894744, 1048894895, 'nl'),
                            (1048894904, 1048895079, 'nl'),
                            (1048895088, 1048895271, 'nl'),
                            (1048895280, 1048895551, 'nl'),
                            (1048895560, 1048895647, 'nl'),
                            (1048895656, 1048895967, 'nl'),
                            (1048895976, 1048896231, 'nl'),
                            (1048896240, 1048896319, 'nl'),
                            (1048896328, 1048896479, 'nl'),
                            (1048896488, 1048896519, 'nl'),
                            (1048896528, 1048896671, 'nl'),
                            (1048896680, 1048896687, 'nl'),
                            (1048896696, 1048896735, 'nl'),
                            (1048896744, 1048896871, 'nl'),
                            (1048896880, 1048896967, 'nl'),
                            (1048896976, 1048897119, 'nl'),
                            (1048897136, 1048897271, 'nl'),
                            (1048897280, 1048897295, 'nl'),
                            (1048897312, 1048897367, 'nl'),
                            (1048897376, 1048897463, 'nl'),
                            (1048897472, 1048897495, 'nl'),
                            (1048897504, 1048897735, 'nl'),
                            (1048897744, 1048898991, 'nl'),
                            (1048899000, 1048899047, 'nl'),
                            (1048899056, 1048899271, 'nl'),
                            (1048899280, 1048899287, 'nl'),
                            (1048899296, 1048899303, 'nl'),
                            (1048899312, 1048899591, 'nl'),
                            (1048899600, 1048900071, 'nl'),
                            (1048900080, 1048900311, 'nl'),
                            (1048900320, 1048900343, 'nl'),
                            (1048900352, 1048900367, 'nl'),
                            (1048900376, 1048900703, 'nl'),
                            (1048900712, 1048900935, 'nl'),
                            (1048900952, 1048901167, 'nl'),
                            (1048901176, 1048901199, 'nl'),
                            (1048901208, 1048901311, 'nl'),
                            (1048901320, 1048901327, 'nl'),
                            (1048901336, 1048901831, 'nl'),
                            (1048901840, 1048901847, 'nl'),
                            (1048901864, 1048902335, 'nl'),
                            (1048902344, 1048902359, 'nl'),
                            (1048902368, 1048902391, 'nl'),
                            (1048902400, 1048902447, 'nl'),
                            (1048902456, 1048902527, 'nl'),
                            (1048902536, 1048902583, 'nl'),
                            (1048902592, 1048902671, 'nl'),
                            (1048902680, 1048903071, 'nl'),
                            (1048903080, 1048903095, 'nl'),
                            (1048903104, 1048903679, 'nl'),
                            (1048920064, 1048936447, 'nl'),
                            (1048952832, 1048953407, 'nl'),
                            (1048953440, 1048954967, 'nl'),
                            (1048954976, 1048969215, 'nl'),
                            (1049016816, 1049016831, 'nl'),
                            (1049395200, 1049405055, 'nl'),
                            (1049405248, 1049405311, 'nl'),
                            (1049405376, 1049405439, 'nl'),
                            (1049405952, 1049407615, 'nl'),
                            (1049408000, 1049409023, 'nl'),
                            (1049409280, 1049411583, 'nl'),
                            (1049698304, 1049706495, 'nl'),
                            (1049707008, 1049707519, 'nl'),
                            (1049710080, 1049711103, 'nl'),
                            (1049711360, 1049711615, 'nl'),
                            (1049713152, 1049713663, 'nl'),
                            (1049714176, 1049714687, 'nl'),
                            (1049715712, 1049716735, 'nl'),
                            (1049718272, 1049722879, 'nl'),
                            (1049739264, 1049755647, 'nl'),
                            (1049768368, 1049768375, 'nl'),
                            (1049927680, 1049935871, 'nl'),
                            (1050450712, 1050450719, 'nl'),
                            (1050647432, 1050647439, 'nl'),
                            (1050869760, 1050935295, 'nl'),
                            (1051017216, 1051033599, 'nl'),
                            (1051066368, 1051084287, 'nl'),
                            (1051084800, 1051096831, 'nl'),
                            (1051097088, 1051098111, 'nl'),
                            (1051099136, 1051099647, 'nl'),
                            (1051099664, 1051099671, 'nl'),
                            (1051099688, 1051099695, 'nl'),
                            (1051099712, 1051099727, 'nl'),
                            (1051099740, 1051099743, 'nl'),
                            (1051099776, 1051099791, 'nl'),
                            (1051099800, 1051099807, 'nl'),
                            (1051099816, 1051099823, 'nl'),
                            (1051099840, 1051099863, 'nl'),
                            (1051099880, 1051099887, 'nl'),
                            (1051099928, 1051099967, 'nl'),
                            (1051099976, 1051099991, 'nl'),
                            (1051100016, 1051100023, 'nl'),
                            (1051100032, 1051100039, 'nl'),
                            (1051100080, 1051100095, 'nl'),
                            (1051100144, 1051100159, 'nl'),
                            (1051100456, 1051100463, 'nl'),
                            (1051100488, 1051100499, 'nl'),
                            (1051100592, 1051100607, 'nl'),
                            (1051100632, 1051100663, 'nl'),
                            (1051100680, 1051100687, 'nl'),
                            (1051100696, 1051100703, 'nl'),
                            (1051100712, 1051100735, 'nl'),
                            (1051100832, 1051100839, 'nl'),
                            (1051100880, 1051100919, 'nl'),
                            (1051100952, 1051100967, 'nl'),
                            (1051101048, 1051101055, 'nl'),
                            (1051101080, 1051101087, 'nl'),
                            (1051101096, 1051101103, 'nl'),
                            (1051101128, 1051101151, 'nl'),
                            (1051101184, 1051101191, 'nl'),
                            (1051101200, 1051101231, 'nl'),
                            (1051101248, 1051101279, 'nl'),
                            (1051101288, 1051101407, 'nl'),
                            (1051101416, 1051101431, 'nl'),
                            (1051101448, 1051101463, 'nl'),
                            (1051101472, 1051101591, 'nl'),
                            (1051101608, 1051101615, 'nl'),
                            (1051101624, 1051101631, 'nl'),
                            (1051101648, 1051101671, 'nl'),
                            (1051101688, 1051101719, 'nl'),
                            (1051101736, 1051101783, 'nl'),
                            (1051101800, 1051101823, 'nl'),
                            (1051101856, 1051101959, 'nl'),
                            (1051101968, 1051101991, 'nl'),
                            (1051102008, 1051102135, 'nl'),
                            (1051102160, 1051102207, 'nl'),
                            (1051102728, 1051103233, 'nl'),
                            (1051103248, 1051103287, 'nl'),
                            (1051103296, 1051103359, 'nl'),
                            (1051103368, 1051103439, 'nl'),
                            (1051103448, 1051103503, 'nl'),
                            (1051103520, 1051103527, 'nl'),
                            (1051103536, 1051103543, 'nl'),
                            (1051103568, 1051103583, 'nl'),
                            (1051103592, 1051103599, 'nl'),
                            (1051103608, 1051103639, 'nl'),
                            (1051103648, 1051103671, 'nl'),
                            (1051103680, 1051103695, 'nl'),
                            (1051103704, 1051103767, 'nl'),
                            (1051103776, 1051103807, 'nl'),
                            (1051103816, 1051103863, 'nl'),
                            (1051103872, 1051103879, 'nl'),
                            (1051103888, 1051103911, 'nl'),
                            (1051103928, 1051103959, 'nl'),
                            (1051103976, 1051103991, 'nl'),
                            (1051104000, 1051104015, 'nl'),
                            (1051104040, 1051104071, 'nl'),
                            (1051104080, 1051104111, 'nl'),
                            (1051104144, 1051104167, 'nl'),
                            (1051104176, 1051104231, 'nl'),
                            (1051104256, 1051104311, 'nl'),
                            (1051104320, 1051104359, 'nl'),
                            (1051104368, 1051104383, 'nl'),
                            (1051104400, 1051104503, 'nl'),
                            (1051104528, 1051104583, 'nl'),
                            (1051104600, 1051104607, 'nl'),
                            (1051104632, 1051104679, 'nl'),
                            (1051104696, 1051104719, 'nl'),
                            (1051104728, 1051104751, 'nl'),
                            (1051104760, 1051104791, 'nl'),
                            (1051104800, 1051104823, 'nl'),
                            (1051104832, 1051104839, 'nl'),
                            (1051104856, 1051104935, 'nl'),
                            (1051104944, 1051104951, 'nl'),
                            (1051104960, 1051104975, 'nl'),
                            (1051104984, 1051104991, 'nl'),
                            (1051105000, 1051105047, 'nl'),
                            (1051105056, 1051105063, 'nl'),
                            (1051105080, 1051105103, 'nl'),
                            (1051105120, 1051105127, 'nl'),
                            (1051105136, 1051105143, 'nl'),
                            (1051105152, 1051105191, 'nl'),
                            (1051105200, 1051105207, 'nl'),
                            (1051105224, 1051105255, 'nl'),
                            (1051105264, 1051105271, 'nl'),
                            (1051105280, 1051105319, 'nl'),
                            (1051105328, 1051105359, 'nl'),
                            (1051105384, 1051105439, 'nl'),
                            (1051105456, 1051105519, 'nl'),
                            (1051105552, 1051105599, 'nl'),
                            (1051105608, 1051105703, 'nl'),
                            (1051105712, 1051105791, 'nl'),
                            (1051105800, 1051105807, 'nl'),
                            (1051105816, 1051105831, 'nl'),
                            (1051105840, 1051105863, 'nl'),
                            (1051105872, 1051105895, 'nl'),
                            (1051105904, 1051105911, 'nl'),
                            (1051105920, 1051105967, 'nl'),
                            (1051105984, 1051105999, 'nl'),
                            (1051106016, 1051106031, 'nl'),
                            (1051106040, 1051106047, 'nl'),
                            (1051106056, 1051106071, 'nl'),
                            (1051106080, 1051106095, 'nl'),
                            (1051106104, 1051106111, 'nl'),
                            (1051106120, 1051106135, 'nl'),
                            (1051106144, 1051106167, 'nl'),
                            (1051106176, 1051106183, 'nl'),
                            (1051106192, 1051106247, 'nl'),
                            (1051106272, 1051106303, 'nl'),
                            (1051106312, 1051106319, 'nl'),
                            (1051106328, 1051106335, 'nl'),
                            (1051106352, 1051106391, 'nl'),
                            (1051106400, 1051106423, 'nl'),
                            (1051106432, 1051106463, 'nl'),
                            (1051106472, 1051106511, 'nl'),
                            (1051106520, 1051106527, 'nl'),
                            (1051106536, 1051106543, 'nl'),
                            (1051106552, 1051106591, 'nl'),
                            (1051106600, 1051106607, 'nl'),
                            (1051106616, 1051106663, 'nl'),
                            (1051106672, 1051106711, 'nl'),
                            (1051106720, 1051106759, 'nl'),
                            (1051106768, 1051106775, 'nl'),
                            (1051106784, 1051106799, 'nl'),
                            (1051106808, 1051106823, 'nl'),
                            (1051106832, 1051106847, 'nl'),
                            (1051106864, 1051106895, 'nl'),
                            (1051106904, 1051106943, 'nl'),
                            (1051106952, 1051106959, 'nl'),
                            (1051106968, 1051106975, 'nl'),
                            (1051106992, 1051106999, 'nl'),
                            (1051107008, 1051107023, 'nl'),
                            (1051107040, 1051107071, 'nl'),
                            (1051107088, 1051107103, 'nl'),
                            (1051107120, 1051107127, 'nl'),
                            (1051107136, 1051107143, 'nl'),
                            (1051107152, 1051107159, 'nl'),
                            (1051107168, 1051107183, 'nl'),
                            (1051107216, 1051107223, 'nl'),
                            (1051107232, 1051107239, 'nl'),
                            (1051107248, 1051107279, 'nl'),
                            (1051107288, 1051107295, 'nl'),
                            (1051107304, 1051107311, 'nl'),
                            (1051107328, 1051107329, 'nl'),
                            (1051107360, 1051107375, 'nl'),
                            (1051107384, 1051107391, 'nl'),
                            (1051107408, 1051107423, 'nl'),
                            (1051107456, 1051107519, 'nl'),
                            (1051107840, 1051115519, 'nl'),
                            (1051121288, 1051121295, 'nl'),
                            (1051123712, 1051125247, 'nl'),
                            (1051125760, 1051131903, 'nl'),
                            (1051577504, 1051577519, 'nl'),
                            (1051577536, 1051577567, 'nl'),
                            (1051577592, 1051577599, 'nl'),
                            (1051577856, 1051578111, 'nl'),
                            (1051578144, 1051578175, 'nl'),
                            (1051578304, 1051578335, 'nl'),
                            (1051578344, 1051578351, 'nl'),
                            (1051820032, 1051852799, 'nl'),
                            (1051994792, 1051994799, 'nl'),
                            (1052042048, 1052042087, 'nl'),
                            (1052176384, 1052178431, 'nl'),
                            (1052247416, 1052247423, 'nl'),
                            (1052250736, 1052250751, 'nl'),
                            (1052254208, 1052255255, 'nl'),
                            (1052255264, 1052255871, 'nl'),
                            (1052255936, 1052257279, 'nl'),
                            (1052260736, 1052260863, 'nl'),
                            (1052261056, 1052261119, 'nl'),
                            (1052268720, 1052268735, 'nl'),
                            (1052278864, 1052278879, 'nl'),
                            (1052311896, 1052311903, 'nl'),
                            (1052316320, 1052316335, 'nl'),
                            (1052324944, 1052324959, 'nl'),
                            (1052325312, 1052325375, 'nl'),
                            (1052334752, 1052334759, 'nl'),
                            (1052335424, 1052335455, 'nl'),
                            (1052337904, 1052337911, 'nl'),
                            (1052340128, 1052340135, 'nl'),
                            (1052340576, 1052340607, 'nl'),
                            (1052343648, 1052343655, 'nl'),
                            (1052344320, 1052344863, 'nl'),
                            (1052345088, 1052345135, 'nl'),
                            (1052345344, 1052345471, 'nl'),
                            (1052345488, 1052345503, 'nl'),
                            (1052345568, 1052345631, 'nl'),
                            (1052345856, 1052346903, 'nl'),
                            (1052347136, 1052347391, 'nl'),
                            (1052361040, 1052361055, 'nl'),
                            (1052364696, 1052364703, 'nl'),
                            (1052377744, 1052377759, 'nl'),
                            (1052378080, 1052378111, 'nl'),
                            (1052379800, 1052379807, 'nl'),
                            (1052380128, 1052380159, 'nl'),
                            (1052384000, 1052384255, 'nl'),
                            (1052388864, 1052389119, 'nl'),
                            (1052395776, 1052396031, 'nl'),
                            (1052399920, 1052399927, 'nl'),
                            (1052402048, 1052402175, 'nl'),
                            (1052403416, 1052403423, 'nl'),
                            (1052403728, 1052403743, 'nl'),
                            (1052409856, 1052409863, 'nl'),
                            (1052409872, 1052409951, 'nl'),
                            (1052411136, 1052412327, 'nl'),
                            (1052412336, 1052412343, 'nl'),
                            (1052412672, 1052412831, 'nl'),
                            (1052412864, 1052413951, 'nl'),
                            (1052423360, 1052423423, 'nl'),
                            (1052435456, 1052435647, 'nl'),
                            (1052435680, 1052436479, 'nl'),
                            (1052454944, 1052454959, 'nl'),
                            (1052454976, 1052455359, 'nl'),
                            (1052455936, 1052456447, 'nl'),
                            (1052456960, 1052457983, 'nl'),
                            (1052458496, 1052458847, 'nl'),
                            (1052458864, 1052458871, 'nl'),
                            (1052479488, 1052479743, 'nl'),
                            (1052480000, 1052483583, 'nl'),
                            (1052494336, 1052494591, 'nl'),
                            (1052786688, 1052803071, 'nl'),
                            (1052901376, 1053032447, 'nl'),
                            (1053130752, 1053138943, 'nl'),
                            (1053331456, 1053331487, 'nl'),
                            (1053331584, 1053331663, 'nl'),
                            (1053331680, 1053331703, 'nl'),
                            (1053331712, 1053331887, 'nl'),
                            (1053331904, 1053331935, 'nl'),
                            (1053332224, 1053332271, 'nl'),
                            (1053332320, 1053332415, 'nl'),
                            (1053332448, 1053332479, 'nl'),
                            (1053340480, 1053340495, 'nl'),
                            (1053349120, 1053349631, 'nl'),
                            (1053573120, 1053581311, 'nl'),
                            (1053824128, 1053824255, 'nl'),
                            (1053894816, 1053894831, 'nl'),
                            (1054097408, 1054105599, 'nl'),
                            (1054113792, 1054121983, 'nl'),
                            (1054343168, 1054351359, 'nl'),
                            (1054720000, 1054867455, 'nl'),
                            (1055220224, 1055220287, 'nl'),
                            (1055220352, 1055220399, 'nl'),
                            (1055223040, 1055223807, 'nl'),
                            (1055232000, 1055232255, 'nl'),
                            (1055232512, 1055233023, 'nl'),
                            (1055234064, 1055234079, 'nl'),
                            (1055472128, 1055472159, 'nl'),
                            (1055472384, 1055472639, 'nl'),
                            (1055522816, 1055588351, 'nl'),
                            (1055784960, 1055850495, 'nl'),
                            (1055995136, 1055995391, 'nl'),
                            (1056571392, 1056669695, 'nl'),
                            (1067474752, 1067474767, 'nl'),
                            (1067918880, 1067918887, 'nl'),
                            (1073381376, 1073381887, 'nl'),
                            (1076292560, 1076292567, 'nl'),
                            (1076295072, 1076295087, 'nl'),
                            (1101619248, 1101619255, 'nl'),
                            (1101681408, 1101681663, 'nl'),
                            (1101685384, 1101685391, 'nl'),
                            (1295777792, 1296039935, 'nl'),
                            (1296237568, 1296237823, 'nl'),
                            (1296238592, 1296239103, 'nl'),
                            (1296239232, 1296239359, 'nl'),
                            (1296241408, 1296242175, 'nl'),
                            (1296242304, 1296242431, 'nl'),
                            (1296244224, 1296244479, 'nl'),
                            (1296245504, 1296245759, 'nl'),
                            (1296246784, 1296247295, 'nl'),
                            (1296251392, 1296251775, 'nl'),
                            (1296258304, 1296259071, 'nl'),
                            (1296259840, 1296260351, 'nl'),
                            (1296592896, 1296594943, 'nl'),
                            (1296603136, 1296605183, 'nl'),
                            (1296607760, 1296607999, 'nl'),
                            (1296609024, 1296609279, 'nl'),
                            (1296633856, 1296635903, 'nl'),
                            (1296687104, 1296689151, 'nl'),
                            (1296707584, 1296708039, 'nl'),
                            (1296708048, 1296709631, 'nl'),
                            (1296791552, 1296793599, 'nl'),
                            (1296795648, 1296795903, 'nl'),
                            (1297561600, 1297563647, 'nl'),
                            (1297588224, 1297590271, 'nl'),
                            (1297956864, 1297965055, 'nl'),
                            (1298067456, 1298071551, 'nl'),
                            (1298096128, 1298098175, 'nl'),
                            (1298135040, 1298137087, 'nl'),
                            (1299005440, 1299009535, 'nl'),
                            (1302331392, 1303379967, 'nl'),
                            (1306411008, 1306413199, 'nl'),
                            (1306413216, 1306419199, 'nl'),
                            (1307123712, 1307131903, 'nl'),
                            (1307254784, 1307255551, 'nl'),
                            (1307255808, 1307262975, 'nl'),
                            (1307662336, 1307662351, 'nl'),
                            (1307697152, 1307701247, 'nl'),
                            (1307734016, 1307738111, 'nl'),
                            (1307811840, 1307815935, 'nl'),
                            (1307828224, 1307832319, 'nl'),
                            (1307914240, 1307918335, 'nl'),
                            (1307922432, 1307926527, 'nl'),
                            (1308033024, 1308033279, 'nl'),
                            (1308078080, 1308078263, 'nl'),
                            (1308078272, 1308078879, 'nl'),
                            (1308078912, 1308080127, 'nl'),
                            (1308098560, 1308360703, 'nl'),
                            (1310220288, 1310222335, 'nl'),
                            (1310246992, 1310247007, 'nl'),
                            (1310247592, 1310247599, 'nl'),
                            (1310247848, 1310247855, 'nl'),
                            (1310248616, 1310248623, 'nl'),
                            (1310392320, 1310408703, 'nl'),
                            (1310666752, 1310668799, 'nl'),
                            (1310683136, 1310685183, 'nl'),
                            (1311293440, 1311295487, 'nl'),
                            (1311328256, 1311330559, 'nl'),
                            (1311330848, 1311330879, 'nl'),
                            (1311330944, 1311331327, 'nl'),
                            (1311361024, 1311363071, 'nl'),
                            (1315733504, 1315737599, 'nl'),
                            (1315766272, 1315770367, 'nl'),
                            (1317686272, 1317686287, 'nl'),
                            (1317686304, 1317686319, 'nl'),
                            (1317830656, 1317832191, 'nl'),
                            (1317832512, 1317832959, 'nl'),
                            (1317833216, 1317835615, 'nl'),
                            (1317835648, 1317847039, 'nl'),
                            (1318000384, 1318000447, 'nl'),
                            (1318002176, 1318002431, 'nl'),
                            (1318005632, 1318005759, 'nl'),
                            (1318006272, 1318006783, 'nl'),
                            (1318592512, 1318600703, 'nl'),
                            (1318961152, 1318969343, 'nl'),
                            (1331865600, 1331869695, 'nl'),
                            (1331894272, 1331896319, 'nl'),
                            (1331920896, 1331922943, 'nl'),
                            (1331948544, 1331948547, 'nl'),
                            (1334113528, 1334113535, 'nl'),
                            (1334650960, 1334650975, 'nl'),
                            (1334651392, 1334651647, 'nl'),
                            (1334684928, 1334685183, 'nl'),
                            (1334824960, 1334829055, 'nl'),
                            (1336563712, 1336567807, 'nl'),
                            (1336655872, 1336657919, 'nl'),
                            (1345847296, 1345978367, 'nl'),
                            (1346109440, 1346240511, 'nl'),
                            (1346433024, 1346439167, 'nl'),
                            (1346440448, 1346440463, 'nl'),
                            (1346440480, 1346441215, 'nl'),
                            (1346461696, 1346469887, 'nl'),
                            (1346715648, 1346723839, 'nl'),
                            (1346994176, 1346998271, 'nl'),
                            (1347362816, 1347366911, 'nl'),
                            (1347379200, 1347383295, 'nl'),
                            (1347403776, 1347407871, 'nl'),
                            (1347739648, 1347747839, 'nl'),
                            (1347756032, 1347760127, 'nl'),
                            (1347780608, 1347784703, 'nl'),
                            (1347788800, 1347792895, 'nl'),
                            (1347822344, 1347822351, 'nl'),
                            (1348067328, 1348071423, 'nl'),
                            (1348086536, 1348086543, 'nl'),
                            (1348354048, 1348358143, 'nl'),
                            (1348444160, 1348448255, 'nl'),
                            (1348730880, 1348861951, 'nl'),
                            (1349517312, 1349763071, 'nl'),
                            (1349771264, 1349779455, 'nl'),
                            (1350434816, 1350565887, 'nl'),
                            (1352404600, 1352404607, 'nl'),
                            (1352445688, 1352445703, 'nl')";

        $sql_query[] = "CREATE TABLE IF NOT EXISTS `ref_language` (
                          `one` char(2) NOT NULL,
                          `two` char(3) NOT NULL,
                          `language` varchar(120) NOT NULL,
                          `native` varchar(80) DEFAULT NULL,
                          `active` tinyint(4) NOT NULL DEFAULT '0', 
                          PRIMARY KEY (`one`),
                          KEY `two` (`two`)
                        )";

        $sql_query[] = "REPLACE INTO `ref_language` (`one`, `two`, `language`, `native`, `active`) VALUES
                        ('nl', 'nld', 'Nederlands', 'Dutch',1),
                        ('en', 'eng', 'English', 'English',1),
                        ('pl', 'pol', 'Polska', 'Polish',0),
                        ('fr', 'fra', 'Français', 'French',0),
                        ('es', 'esp', 'Español', 'Spanish',0),
                        ('it', 'ita', 'Italiano', 'Italian',0),
                        ('de', 'deu', 'Deutsch', 'German',1)";
        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `ref_timezone` (
                          `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
                          `abbr` varchar(8) NOT NULL,
                          `name` varchar(80) NOT NULL,
                          `utc` varchar(18) NOT NULL,
                          `hours` tinyint(4) NOT NULL,
                          PRIMARY KEY (`id`),
                          UNIQUE KEY `name` (`name`),
                          KEY `abbr` (`abbr`),
                          KEY `utc` (`utc`)
                        )";
        
        $sql_query[] = "REPLACE INTO `ref_timezone` (`id`, `abbr`, `name`, `utc`, `hours`) VALUES
                            (1, 'BIT', 'Baker Island Time', 'UTC-12', -12),
                            (2, 'SST', 'Samoa Standard Time', 'UTC-11', -11),
                            (3, 'CKT', 'Cook Island Time', 'UTC-10', -10),
                            (4, 'HAST', 'Hawaii-Aleutian Standard Time', 'UTC-10', -10),
                            (5, 'TAHT', 'Tahiti Time', 'UTC-10', -10),
                            (6, 'MIT', 'Marquesas Islands Time', 'UTC-9:30', -10),
                            (7, 'AKST', 'Alaska Standard Time', 'UTC-9', -9),
                            (8, 'GIT', 'Gambier Island Time', 'UTC-9', -9),
                            (9, 'CIST', 'Clipperton Island Standard Time', 'UTC-8', -8),
                            (10, 'PST', 'Pacific Standard Time (North America)', 'UTC-8', -8),
                            (11, 'MST', 'Mountain Standard Time (North America)', 'UTC-7', -7),
                            (12, 'PDT', 'Pacific Daylight Time (North America)', 'UTC-7', -7),
                            (13, 'THA', 'Thailand Standard Time', 'UTC-7', -7),
                            (14, 'CST', 'Central Standard Time (North America)', 'UTC-6', -6),
                            (15, 'EAST', 'Easter Island Standard Time', 'UTC-6', -6),
                            (16, 'GALT', 'Galapagos Time', 'UTC-6', -6),
                            (17, 'MDT', 'Mountain Daylight Time (North America)', 'UTC-6', -6),
                            (18, 'CDT', 'Central Daylight Time (North America)', 'UTC-5', -5),
                            (19, 'COT', 'Colombia Time', 'UTC-5', -5),
                            (20, 'ECT', 'Ecuador Time', 'UTC-5', -5),
                            (21, 'EST', 'Eastern Standard Time (North America)', 'UTC-5', -5),
                            (22, 'VET', 'Venezuelan Standard Time', 'UTC-4:30', -5),
                            (23, 'AST', 'Atlantic Standard Time', 'UTC-4', -4),
                            (24, 'BOT', 'Bolivia Time', 'UTC-4', -4),
                            (25, 'CLT', 'Chile Standard Time', 'UTC-4', -4),
                            (26, 'COST', 'Colombia Summer Time', 'UTC-4', -4),
                            (27, 'ECT', 'Eastern Caribbean Time (does not recognise DST)', 'UTC-4', -4),
                            (28, 'EDT', 'Eastern Daylight Time (North America)', 'UTC-4', -4),
                            (29, 'FKST', 'Falkland Islands Standard Time', 'UTC-4', -4),
                            (30, 'GYT', 'Guyana Time', 'UTC-4', -4),
                            (31, 'NT', 'Newfoundland Time', 'UTC-3:30', -4),
                            (32, 'ART', 'Argentina Time', 'UTC-3', -3),
                            (33, 'BRT', 'Brasilia Time', 'UTC-3', -3),
                            (34, 'CLST', 'Chile Summer Time', 'UTC-3', -3),
                            (35, 'GFT', 'French Guiana Time', 'UTC-3', -3),
                            (36, 'UYT', 'Uruguay Standard Time', 'UTC-3', -3),
                            (37, 'NDT', 'Newfoundland Daylight Time', 'UTC-2:30', -3),
                            (38, 'GST', 'South Georgia and the South Sandwich Islands', 'UTC-2', -2),
                            (39, 'UYST', 'Uruguay Summer Time', 'UTC-2', -2),
                            (40, 'AZOST', 'Azores Standard Time', 'UTC-1', -1),
                            (41, 'CVT', 'Cape Verde Time', 'UTC-1', -1),
                            (42, 'GMT', 'Greenwich Mean Time', 'UTC+0', 0),
                            (43, 'WET', 'Western European Time', 'UTC+0', 0),
                            (44, 'BST', 'British Summer Time (British Standard Time from Feb 1968 to Oct 1971)', 'UTC+1', 1),
                            (45, 'CET', 'Central European Time', 'UTC+1', 1),
                            (46, 'WAT', 'West Africa Time', 'UTC+1', 1),
                            (47, 'WEST', 'Western European Summer Time', 'UTC+1', 1),
                            (48, 'CAT', 'Central Africa Time', 'UTC+2', 2),
                            (49, 'CEST', 'Central European Summer Time', 'UTC+2', 2),
                            (50, 'EET', 'Eastern European Time', 'UTC+2', 2),
                            (51, 'IST', 'Israel Standard Time', 'UTC+2', 2),
                            (52, 'SAST', 'South African Standard Time', 'UTC+2', 2),
                            (53, 'AST', 'Arab Standard Time (Kuwait, Riyadh)', 'UTC+3', 3),
                            (54, 'AST', 'Arabic Standard Time (Baghdad)', 'UTC+3', 3),
                            (55, 'EAT', 'East Africa Time', 'UTC+3', 3),
                            (56, 'EEST', 'Eastern European Summer Time', 'UTC+3', 3),
                            (57, 'MSK', 'Moscow Standard Time', 'UTC+3', 3),
                            (58, 'IRST', 'Iran Standard Time', 'UTC+3:30', 4),
                            (59, 'AMT', 'Armenia Time', 'UTC+4', 4),
                            (60, 'AST', 'Arabian Standard Time (Abu Dhabi, Muscat)', 'UTC+4', 4),
                            (61, 'AZT', 'Azerbaijan Time', 'UTC+4', 4),
                            (62, 'GET', 'Georgia Standard Time', 'UTC+4', 4),
                            (63, 'MUT', 'Mauritius Time', 'UTC+4', 4),
                            (64, 'RET', 'Réunion Time', 'UTC+4', 4),
                            (65, 'SAMT', 'Samara Time', 'UTC+4', 4),
                            (66, 'SCT', 'Seychelles Time', 'UTC+4', 4),
                            (67, 'AFT', 'Afghanistan Time', 'UTC+4:30', 5),
                            (68, 'AMST', 'Armenia Summer Time', 'UTC+5', 5),
                            (69, 'HMT', 'Heard and McDonald Islands Time', 'UTC+5', 5),
                            (70, 'PKT', 'Pakistan Standard Time', 'UTC+5', 5),
                            (71, 'YEKT', 'Yekaterinburg Time', 'UTC+5', 5),
                            (72, 'IST', 'Indian Standard Time', 'UTC+5:30', 6),
                            (73, 'SLT', 'Sri Lanka Time', 'UTC+5:30', 6),
                            (74, 'NPT', 'Nepal Time', 'UTC+5:45', 6),
                            (75, 'BIOT', 'British Indian Ocean Time', 'UTC+6', 6),
                            (76, 'BST', 'Bangladesh Standard Time', 'UTC+6', 6),
                            (77, 'BTT', 'Bhutan Time', 'UTC+6', 6),
                            (78, 'OMST', 'Omsk Time', 'UTC+6', 6),
                            (79, 'CCT', 'Cocos Islands Time', 'UTC+6:30', 7),
                            (80, 'MST', 'Myanmar Standard Time', 'UTC+6:30', 7),
                            (81, 'CXT', 'Christmas Island Time', 'UTC+7', 7),
                            (82, 'KRAT', 'Krasnoyarsk Time', 'UTC+7', 7),
                            (83, 'ACT', 'ASEAN Common Time', 'UTC+8', 8),
                            (84, 'AWST', 'Australian Western Standard Time', 'UTC+8', 8),
                            (85, 'BDT', 'Brunei Time', 'UTC+8', 8),
                            (86, 'CST', 'China Standard Time', 'UTC+8', 8),
                            (87, 'HKT', 'Hong Kong Time', 'UTC+8', 8),
                            (88, 'IRKT', 'Irkutsk Time', 'UTC+8', 8),
                            (89, 'MST', 'Malaysian Standard Time', 'UTC+8', 8),
                            (90, 'PST', 'Philippine Standard Time', 'UTC+8', 8),
                            (91, 'SST', 'Singapore Standard Time', 'UTC+8', 8),
                            (92, 'JST', 'Japan Standard Time', 'UTC+9', 9),
                            (93, 'KST', 'Korea Standard Time', 'UTC+9', 9),
                            (94, 'YAKT', 'Yakutsk Time', 'UTC+9', 9),
                            (95, 'ACST', 'Australian Central Standard Time', 'UTC+9:30', 10),
                            (96, 'AEST', 'Australian Eastern Standard Time', 'UTC+10', 10),
                            (97, 'ChST', 'Chamorro Standard Time', 'UTC+10', 10),
                            (98, 'VLAT', 'Vladivostok Time', 'UTC+10', 10),
                            (99, 'LHST', 'Lord Howe Standard Time', 'UTC+10:30', 11),
                            (100, 'MAGT', 'Magadan Time', 'UTC+11', 11),
                            (101, 'SBT', 'Solomon Islands Time', 'UTC+11', 11),
                            (102, 'NFT', 'Norfolk Time', 'UTC+11:30', 12),
                            (103, 'FJT', 'Fiji Time', 'UTC+12', 12),
                            (104, 'GILT', 'Gilbert Island Time', 'UTC+12', 12),
                            (105, 'PETT', 'Kamchatka Time', 'UTC+12', 12),
                            (106, 'CHAST', 'Chatham Standard Time', 'UTC+12:45', 13),
                            (107, 'PHOT', 'Phoenix Island Time', 'UTC+13', 13),
                            (108, 'LINT', 'Line Islands Time', 'UTC+14', 14)";

        $sql_query[] = "CREATE TABLE IF NOT EXISTS `ref_zoneinfo` (
                          `zoneinfo` varchar(40) NOT NULL,
                          `offset` varchar(16) DEFAULT NULL,
                          `summer` varchar(16) DEFAULT NULL,
                          `country` char(2) NOT NULL,
                          PRIMARY KEY (`zoneinfo`),
                          KEY `country` (`country`)
                        )";

        $sql_query[] = "REPLACE INTO `ref_zoneinfo` (`zoneinfo`, `offset`, `summer`, `country`) VALUES
                            ('Europe/Andorra', 'UTC+1', 'UTC+2', 'ad'),
                            ('Asia/Dubai', 'UTC+4', NULL, 'ae'),
                            ('Asia/Kabul', 'UTC+4:30', NULL, 'af'),
                            ('America/Antigua', 'UTC-4', NULL, 'ag'),
                            ('America/Anguilla', 'UTC-4', NULL, 'ai'),
                            ('Europe/Tirane', 'UTC+1', 'UTC+2', 'al'),
                            ('Asia/Yerevan', 'UTC+4', 'UTC+5', 'am'),
                            ('America/Curacao', 'UTC-4', NULL, 'an'),
                            ('Africa/Luanda', 'UTC+1', NULL, 'ao'),
                            ('Antarctica/McMurdo', 'UTC+12', 'UTC+13', 'aq'),
                            ('Antarctica/South_Pole', 'UTC+12', 'UTC+13', 'aq'),
                            ('Antarctica/Rothera', 'UTC-3', NULL, 'aq'),
                            ('Antarctica/Palmer', 'UTC-4', 'UTC-3', 'aq'),
                            ('Antarctica/Mawson', 'UTC+6', NULL, 'aq'),
                            ('Antarctica/Davis', 'UTC+7', NULL, 'aq'),
                            ('Antarctica/Casey', 'UTC+8', NULL, 'aq'),
                            ('Antarctica/Vostok', NULL, NULL, 'aq'),
                            ('Antarctica/DumontDUrville', 'UTC+10', NULL, 'aq'),
                            ('Antarctica/Syowa', 'UTC+3', NULL, 'aq'),
                            ('America/Argentina/Buenos_Aires', 'UTC-3', 'UTC-2', 'ar'),
                            ('America/Argentina/Cordoba', 'UTC-3', 'UTC-2', 'ar'),
                            ('America/Argentina/Salta', 'UTC-3', NULL, 'ar'),
                            ('America/Argentina/Jujuy', 'UTC-3', NULL, 'ar'),
                            ('America/Argentina/Tucuman', 'UTC-3', 'UTC-2', 'ar'),
                            ('America/Argentina/Catamarca', 'UTC-3', NULL, 'ar'),
                            ('America/Argentina/La_Rioja', 'UTC-3', NULL, 'ar'),
                            ('America/Argentina/San_Juan', 'UTC-3', NULL, 'ar'),
                            ('America/Argentina/Mendoza', 'UTC-3', NULL, 'ar'),
                            ('America/Argentina/San_Luis', 'UTC-4', 'UTC-3', 'ar'),
                            ('America/Argentina/Rio_Gallegos', 'UTC-3', NULL, 'ar'),
                            ('America/Argentina/Ushuaia', 'UTC-3', NULL, 'ar'),
                            ('Pacific/Pago_Pago', 'UTC-11', NULL, 'as'),
                            ('Europe/Vienna', 'UTC+1', 'UTC+2', 'at'),
                            ('Australia/Lord_Howe', 'UTC+10:30', 'UTC+11', 'au'),
                            ('Australia/Hobart', 'UTC+10', 'UTC+11', 'au'),
                            ('Australia/Currie', 'UTC+10', 'UTC+11', 'au'),
                            ('Australia/Melbourne', 'UTC+10', 'UTC+11', 'au'),
                            ('Australia/Sydney', 'UTC+10', 'UTC+11', 'au'),
                            ('Australia/Broken_Hill', 'UTC+9:30', 'UTC+10:30', 'au'),
                            ('Australia/Brisbane', 'UTC+10', NULL, 'au'),
                            ('Australia/Lindeman', 'UTC+10', NULL, 'au'),
                            ('Australia/Adelaide', 'UTC+9:30', 'UTC+10:30', 'au'),
                            ('Australia/Darwin', 'UTC+9:30', NULL, 'au'),
                            ('Australia/Perth', 'UTC+8', NULL, 'au'),
                            ('Australia/Eucla', 'UTC+8:45', 'UTC+9:45', 'au'),
                            ('America/Aruba', 'UTC-4', NULL, 'aw'),
                            ('Europe/Mariehamn', 'UTC+2', 'UTC+3', 'ax'),
                            ('Asia/Baku', 'UTC+4', 'UTC+5', 'az'),
                            ('Europe/Sarajevo', 'UTC+1', 'UTC+2', 'ba'),
                            ('America/Barbados', 'UTC-4', NULL, 'bb'),
                            ('Asia/Dhaka', 'UTC+6', NULL, 'bd'),
                            ('Europe/Brussels', 'UTC+1', 'UTC+2', 'be'),
                            ('Africa/Ouagadougou', 'UTC', NULL, 'bf'),
                            ('Europe/Sofia', 'UTC+2', 'UTC+3', 'bg'),
                            ('Asia/Bahrain', 'UTC+3', NULL, 'bh'),
                            ('Africa/Bujumbura', 'UTC+2', NULL, 'bi'),
                            ('Africa/Porto-Novo', 'UTC+1', NULL, 'bj'),
                            ('America/St_Barthelemy', 'UTC-4', NULL, 'bl'),
                            ('Atlantic/Bermuda', 'UTC-4', NULL, 'bm'),
                            ('Asia/Brunei', 'UTC+8', NULL, 'bn'),
                            ('America/La_Paz', 'UTC-4', NULL, 'bo'),
                            ('America/Noronha', 'UTC-2', NULL, 'br'),
                            ('America/Belem', 'UTC-3', NULL, 'br'),
                            ('America/Fortaleza', 'UTC-3', NULL, 'br'),
                            ('America/Recife', 'UTC-3', NULL, 'br'),
                            ('America/Araguaina', 'UTC-3', NULL, 'br'),
                            ('America/Maceio', 'UTC-3', NULL, 'br'),
                            ('America/Bahia', 'UTC-3', NULL, 'br'),
                            ('America/Sao_Paulo', 'UTC-3', 'UTC-2', 'br'),
                            ('America/Campo_Grande', 'UTC-4', 'UTC-3', 'br'),
                            ('America/Cuiaba', 'UTC-4', 'UTC-3', 'br'),
                            ('America/Santarem', 'UTC-3', NULL, 'br'),
                            ('America/Porto_Velho', 'UTC-4', NULL, 'br'),
                            ('America/Boa_Vista', 'UTC-4', NULL, 'br'),
                            ('America/Manaus', 'UTC-4', NULL, 'br'),
                            ('America/Eirunepe', 'UTC-4', NULL, 'br'),
                            ('America/Rio_Branco', 'UTC-4', NULL, 'br'),
                            ('America/Nassau', 'UTC-4', 'UTC-3', 'bs'),
                            ('Asia/Thimphu', 'UTC+6', NULL, 'bt'),
                            ('Africa/Gaborone', 'UTC+2', NULL, 'bw'),
                            ('Europe/Minsk', 'UTC+2', 'UTC+3', 'by'),
                            ('America/Belize', 'UTC-6', NULL, 'bz'),
                            ('America/St_Johns', 'UTC-3:30', 'UTC-2:30', 'ca'),
                            ('America/Halifax', 'UTC-4', 'UTC-3', 'ca'),
                            ('America/Glace_Bay', 'UTC-4', 'UTC-3', 'ca'),
                            ('America/Moncton', 'UTC-4', 'UTC-3', 'ca'),
                            ('America/Goose_Bay', 'UTC-4', 'UTC-3', 'ca'),
                            ('America/Blanc-Sablon', 'UTC-4', NULL, 'ca'),
                            ('America/Montreal', 'UTC-5', 'UTC-4', 'ca'),
                            ('America/Toronto', 'UTC-5', 'UTC-4', 'ca'),
                            ('America/Nipigon', 'UTC-5', 'UTC-4', 'ca'),
                            ('America/Thunder_Bay', 'UTC-5', 'UTC-4', 'ca'),
                            ('America/Iqaluit', 'UTC-5', 'UTC-4', 'ca'),
                            ('America/Pangnirtung', 'UTC-5', 'UTC-4', 'ca'),
                            ('America/Resolute', 'UTC-5', 'UTC-4', 'ca'),
                            ('America/Atikokan', 'UTC-5', NULL, 'ca'),
                            ('America/Rankin_Inlet', 'UTC-6', 'UTC-5', 'ca'),
                            ('America/Winnipeg', 'UTC-6', 'UTC-5', 'ca'),
                            ('America/Rainy_River', 'UTC-6', 'UTC-5', 'ca'),
                            ('America/Regina', 'UTC-6', NULL, 'ca'),
                            ('America/Swift_Current', 'UTC-6', NULL, 'ca'),
                            ('America/Edmonton', 'UTC-7', 'UTC-6', 'ca'),
                            ('America/Cambridge_Bay', 'UTC-7', 'UTC-6', 'ca'),
                            ('America/Yellowknife', 'UTC-7', 'UTC-6', 'ca'),
                            ('America/Inuvik', 'UTC-7', 'UTC-6', 'ca'),
                            ('America/Dawson_Creek', 'UTC-7', NULL, 'ca'),
                            ('America/Vancouver', 'UTC-8', 'UTC-7', 'ca'),
                            ('America/Whitehorse', 'UTC-8', 'UTC-7', 'ca'),
                            ('America/Dawson', 'UTC-8', 'UTC-7', 'ca'),
                            ('Indian/Cocos', 'UTC+6:30', NULL, 'cc'),
                            ('Africa/Kinshasa', 'UTC+1', NULL, 'cd'),
                            ('Africa/Lubumbashi', 'UTC+2', NULL, 'cd'),
                            ('Africa/Bangui', 'UTC+1', NULL, 'cf'),
                            ('Africa/Brazzaville', 'UTC+1', NULL, 'cg'),
                            ('Europe/Zurich', 'UTC+1', 'UTC+2', 'ch'),
                            ('Africa/Abidjan', 'UTC', NULL, 'ci'),
                            ('Pacific/Rarotonga', 'UTC-10', NULL, 'ck'),
                            ('America/Santiago', 'UTC-4', 'UTC-3', 'cl'),
                            ('Pacific/Easter', 'UTC-6', 'UTC-5', 'cl'),
                            ('Africa/Douala', 'UTC+1', NULL, 'cm'),
                            ('Asia/Shanghai', 'UTC+8', NULL, 'cn'),
                            ('Asia/Harbin', 'UTC+8', NULL, 'cn'),
                            ('Asia/Chongqing', 'UTC+8', NULL, 'cn'),
                            ('Asia/Urumqi', 'UTC+8', NULL, 'cn'),
                            ('Asia/Kashgar', 'UTC+8', NULL, 'cn'),
                            ('America/Bogota', 'UTC-5', NULL, 'co'),
                            ('America/Costa_Rica', 'UTC-6', NULL, 'cr'),
                            ('America/Havana', 'UTC-5', 'UTC-4', 'cu'),
                            ('Atlantic/Cape_Verde', 'UTC-1', NULL, 'cv'),
                            ('Indian/Christmas', 'UTC+7', NULL, 'cx'),
                            ('Asia/Nicosia', 'UTC+2', 'UTC+3', 'cy'),
                            ('Europe/Prague', 'UTC+1', 'UTC+2', 'cz'),
                            ('Europe/Berlin', 'UTC+1', 'UTC+2', 'de'),
                            ('Africa/Djibouti', 'UTC+3', NULL, 'dj'),
                            ('Europe/Copenhagen', 'UTC+1', 'UTC+2', 'dk'),
                            ('America/Dominica', 'UTC-4', NULL, 'dm'),
                            ('America/Santo_Domingo', 'UTC-4', NULL, 'do'),
                            ('Africa/Algiers', 'UTC+1', NULL, 'dz'),
                            ('America/Guayaquil', 'UTC-5', NULL, 'ec'),
                            ('Pacific/Galapagos', 'UTC-6', NULL, 'ec'),
                            ('Europe/Tallinn', 'UTC+2', 'UTC+3', 'ee'),
                            ('Africa/Cairo', 'UTC+2', NULL, 'eg'),
                            ('Africa/El_Aaiun', 'UTC', NULL, 'eh'),
                            ('Africa/Asmara', 'UTC+3', NULL, 'er'),
                            ('Europe/Madrid', 'UTC+1', 'UTC+2', 'es'),
                            ('Africa/Ceuta', 'UTC+1', 'UTC+2', 'es'),
                            ('Atlantic/Canary', 'UTC', 'UTC+1', 'es'),
                            ('Africa/Addis_Ababa', 'UTC+3', NULL, 'et'),
                            ('Europe/Helsinki', 'UTC+2', 'UTC+3', 'fi'),
                            ('Pacific/Fiji', 'UTC+12', NULL, 'fj'),
                            ('Atlantic/Stanley', 'UTC-4', 'UTC-3', 'fk'),
                            ('Pacific/Truk', 'UTC+10', NULL, 'fm'),
                            ('Pacific/Ponape', 'UTC+11', NULL, 'fm'),
                            ('Pacific/Kosrae', 'UTC+11', NULL, 'fm'),
                            ('Atlantic/Faroe', 'UTC', 'UTC+1', 'fo'),
                            ('Europe/Paris', 'UTC+1', 'UTC+2', 'fr'),
                            ('Africa/Libreville', 'UTC+1', NULL, 'ga'),
                            ('Europe/London', 'UTC', 'UTC+1', 'gb'),
                            ('America/Grenada', 'UTC-4', NULL, 'gd'),
                            ('Asia/Tbilisi', 'UTC+4', NULL, 'ge'),
                            ('America/Cayenne', 'UTC-3', NULL, 'gf'),
                            ('Europe/Guernsey', 'UTC', 'UTC+1', 'gg'),
                            ('Africa/Accra', 'UTC', NULL, 'gh'),
                            ('Europe/Gibraltar', 'UTC+1', 'UTC+2', 'gi'),
                            ('America/Godthab', 'UTC-3', 'UTC-2', 'gl'),
                            ('America/Danmarkshavn', 'UTC', NULL, 'gl'),
                            ('America/Scoresbysund', 'UTC-1', 'UTC', 'gl'),
                            ('America/Thule', 'UTC-4', 'UTC-3', 'gl'),
                            ('Africa/Banjul', 'UTC', NULL, 'gm'),
                            ('Africa/Conakry', 'UTC', NULL, 'gn'),
                            ('America/Guadeloupe', 'UTC-4', NULL, 'gp'),
                            ('Africa/Malabo', 'UTC+1', NULL, 'gq'),
                            ('Europe/Athens', 'UTC+2', 'UTC+3', 'gr'),
                            ('Atlantic/South_Georgia', 'UTC-2', NULL, 'gs'),
                            ('America/Guatemala', 'UTC-6', NULL, 'gt'),
                            ('Pacific/Guam', 'UTC+10', NULL, 'gu'),
                            ('Africa/Bissau', 'UTC', NULL, 'gw'),
                            ('America/Guyana', 'UTC-4', NULL, 'gy'),
                            ('Asia/Hong_Kong', 'UTC+8', NULL, 'hk'),
                            ('America/Tegucigalpa', 'UTC-6', NULL, 'hn'),
                            ('Europe/Zagreb', 'UTC+1', 'UTC+2', 'hr'),
                            ('America/Port-au-Prince', 'UTC-5', NULL, 'ht'),
                            ('Europe/Budapest', 'UTC+1', 'UTC+2', 'hu'),
                            ('Asia/Jakarta', 'UTC+7', NULL, 'id'),
                            ('Asia/Pontianak', 'UTC+7', NULL, 'id'),
                            ('Asia/Makassar', 'UTC+8', NULL, 'id'),
                            ('Asia/Jayapura', 'UTC+9', NULL, 'id'),
                            ('Europe/Dublin', 'UTC', 'UTC+1', 'ie'),
                            ('Asia/Jerusalem', 'UTC+2', 'UTC+3', 'il'),
                            ('Europe/Isle_of_Man', 'UTC', 'UTC+1', 'im'),
                            ('Asia/Kolkata', 'UTC+5:30', NULL, 'in'),
                            ('Indian/Chagos', 'UTC+6', NULL, 'io'),
                            ('Asia/Baghdad', 'UTC+3', NULL, 'iq'),
                            ('Asia/Tehran', 'UTC+3:30', 'UTC+4:30', 'ir'),
                            ('Atlantic/Reykjavik', 'UTC', NULL, 'is'),
                            ('Europe/Rome', 'UTC+1', 'UTC+2', 'it'),
                            ('Europe/Jersey', 'UTC', 'UTC+1', 'je'),
                            ('America/Jamaica', 'UTC-5', NULL, 'jm'),
                            ('Asia/Amman', 'UTC+2', 'UTC+3', 'jo'),
                            ('Asia/Tokyo', 'UTC+9', NULL, 'jp'),
                            ('Africa/Nairobi', 'UTC+3', NULL, 'ke'),
                            ('Asia/Bishkek', 'UTC+6', NULL, 'kg'),
                            ('Asia/Phnom_Penh', 'UTC+7', NULL, 'kh'),
                            ('Pacific/Tarawa', 'UTC+12', NULL, 'ki'),
                            ('Pacific/Enderbury', 'UTC+13', NULL, 'ki'),
                            ('Pacific/Kiritimati', 'UTC+14', NULL, 'ki'),
                            ('Indian/Comoro', 'UTC+3', NULL, 'km'),
                            ('America/St_Kitts', 'UTC-4', NULL, 'kn'),
                            ('Asia/Pyongyang', 'UTC+9', NULL, 'kp'),
                            ('Asia/Seoul', 'UTC+9', NULL, 'kr'),
                            ('Asia/Kuwait', 'UTC+3', NULL, 'kw'),
                            ('America/Cayman', 'UTC-5', NULL, 'ky'),
                            ('Asia/Almaty', 'UTC+6', NULL, 'kz'),
                            ('Asia/Qyzylorda', 'UTC+6', NULL, 'kz'),
                            ('Asia/Aqtobe', 'UTC+5', NULL, 'kz'),
                            ('Asia/Aqtau', 'UTC+5', NULL, 'kz'),
                            ('Asia/Oral', 'UTC+5', NULL, 'kz'),
                            ('Asia/Vientiane', 'UTC+7', NULL, 'la'),
                            ('Asia/Beirut', 'UTC+2', 'UTC+3', 'lb'),
                            ('America/St_Lucia', 'UTC-4', NULL, 'lc'),
                            ('Europe/Vaduz', 'UTC+1', 'UTC+2', 'li'),
                            ('Asia/Colombo', 'UTC+5:30', NULL, 'lk'),
                            ('Africa/Monrovia', 'UTC', NULL, 'lr'),
                            ('Africa/Maseru', 'UTC+2', NULL, 'ls'),
                            ('Europe/Vilnius', 'UTC+2', 'UTC+3', 'lt'),
                            ('Europe/Luxembourg', 'UTC+1', 'UTC+2', 'lu'),
                            ('Europe/Riga', 'UTC+2', 'UTC+3', 'lv'),
                            ('Africa/Tripoli', 'UTC+2', NULL, 'ly'),
                            ('Africa/Casablanca', 'UTC', NULL, 'ma'),
                            ('Europe/Monaco', 'UTC+1', 'UTC+2', 'mc'),
                            ('Europe/Chisinau', 'UTC+2', 'UTC+3', 'md'),
                            ('Europe/Podgorica', 'UTC+1', 'UTC+2', 'me'),
                            ('America/Marigot', 'UTC-4', NULL, 'mf'),
                            ('Indian/Antananarivo', 'UTC+3', NULL, 'mg'),
                            ('Pacific/Majuro', 'UTC+12', NULL, 'mh'),
                            ('Pacific/Kwajalein', 'UTC+12', NULL, 'mh'),
                            ('Europe/Skopje', 'UTC+1', 'UTC+2', 'mk'),
                            ('Africa/Bamako', 'UTC', NULL, 'ml'),
                            ('Asia/Rangoon', 'UTC+6:30', NULL, 'mm'),
                            ('Asia/Ulaanbaatar', 'UTC+8', NULL, 'mn'),
                            ('Asia/Hovd', 'UTC+7', NULL, 'mn'),
                            ('Asia/Choibalsan', 'UTC+8', NULL, 'mn'),
                            ('Asia/Macau', 'UTC+8', NULL, 'mo'),
                            ('Pacific/Saipan', 'UTC+10', NULL, 'mp'),
                            ('America/Martinique', 'UTC-4', NULL, 'mq'),
                            ('Africa/Nouakchott', 'UTC', NULL, 'mr'),
                            ('America/Montserrat', 'UTC-4', NULL, 'ms'),
                            ('Europe/Malta', 'UTC+1', 'UTC+2', 'mt'),
                            ('Indian/Mauritius', 'UTC+4', NULL, 'mu'),
                            ('Indian/Maldives', 'UTC+5', NULL, 'mv'),
                            ('Africa/Blantyre', 'UTC+2', NULL, 'mw'),
                            ('America/Mexico_City', 'UTC-6', 'UTC-5', 'mx'),
                            ('America/Cancun', 'UTC-6', 'UTC-5', 'mx'),
                            ('America/Merida', 'UTC-6', 'UTC-5', 'mx'),
                            ('America/Monterrey', 'UTC-6', 'UTC-5', 'mx'),
                            ('America/Mazatlan', 'UTC-7', 'UTC-6', 'mx'),
                            ('America/Chihuahua', 'UTC-7', 'UTC-6', 'mx'),
                            ('America/Hermosillo', 'UTC-7', NULL, 'mx'),
                            ('America/Tijuana', 'UTC-8', 'UTC-7', 'mx'),
                            ('Asia/Kuala_Lumpur', 'UTC+8', NULL, 'my'),
                            ('Asia/Kuching', 'UTC+8', NULL, 'my'),
                            ('Africa/Maputo', 'UTC+2', NULL, 'mz'),
                            ('Africa/Windhoek', 'UTC+1', 'UTC+2', 'na'),
                            ('Pacific/Noumea', 'UTC+11', NULL, 'nc'),
                            ('Africa/Niamey', 'UTC+1', NULL, 'ne'),
                            ('Pacific/Norfolk', 'UTC+11:30', NULL, 'nf'),
                            ('Africa/Lagos', 'UTC+1', NULL, 'ng'),
                            ('America/Managua', 'UTC-6', NULL, 'ni'),
                            ('Europe/Amsterdam', 'UTC+1', NULL, 'nl'),
                            ('Europe/Oslo', 'UTC+1', 'UTC+2', 'no'),
                            ('Asia/Katmandu', 'UTC+5:45', NULL, 'np'),
                            ('Pacific/Nauru', 'UTC+12', NULL, 'nr'),
                            ('Pacific/Niue', 'UTC-11', NULL, 'nu'),
                            ('Pacific/Auckland', 'UTC+12', 'UTC+13', 'nz'),
                            ('Pacific/Chatham', 'UTC+12:45', 'UTC+13:45', 'nz'),
                            ('Asia/Muscat', 'UTC+4', NULL, 'om'),
                            ('America/Panama', 'UTC-5', NULL, 'pa'),
                            ('America/Lima', 'UTC-5', NULL, 'pe'),
                            ('Pacific/Tahiti', 'UTC-10', NULL, 'pf'),
                            ('Pacific/Marquesas', 'UTC+9:30', NULL, 'pf'),
                            ('Pacific/Gambier', 'UTC-9', NULL, 'pf'),
                            ('Pacific/Port_Moresby', 'UTC+10', NULL, 'pg'),
                            ('Asia/Manila', 'UTC+8', NULL, 'ph'),
                            ('Asia/Karachi', 'UTC+6', NULL, 'pk'),
                            ('Europe/Warsaw', 'UTC+1', 'UTC+2', 'pl'),
                            ('America/Miquelon', 'UTC-3', 'UTC-2', 'pm'),
                            ('Pacific/Pitcairn', 'UTC-8', NULL, 'pn'),
                            ('America/Puerto_Rico', 'UTC-4', NULL, 'pr'),
                            ('Asia/Gaza', 'UTC+2', 'UTC+3', 'ps'),
                            ('Europe/Lisbon', 'UTC', 'UTC+1', 'pt'),
                            ('Atlantic/Madeira', 'UTC', 'UTC+1', 'pt'),
                            ('Atlantic/Azores', 'UTC-1', 'UTC', 'pt'),
                            ('Pacific/Palau', 'UTC+9', NULL, 'pw'),
                            ('America/Asuncion', 'UTC-4', 'UTC-3', 'py'),
                            ('Asia/Qatar', 'UTC+3', NULL, 'qa'),
                            ('Indian/Reunion', 'UTC+4', NULL, 're'),
                            ('Europe/Bucharest', 'UTC+2', 'UTC+3', 'ro'),
                            ('Europe/Belgrade', 'UTC+1', 'UTC+2', 'rs'),
                            ('Europe/Kaliningrad', 'UTC+2', 'UTC+3', 'ru'),
                            ('Europe/Moscow', 'UTC+3', 'UTC+4', 'ru'),
                            ('Europe/Volgograd', 'UTC+3', 'UTC+4', 'ru'),
                            ('Europe/Samara', 'UTC+4', 'UTC+5', 'ru'),
                            ('Asia/Yekaterinburg', 'UTC+5', 'UTC+6', 'ru'),
                            ('Asia/Omsk', 'UTC+6', 'UTC+7', 'ru'),
                            ('Asia/Novosibirsk', 'UTC+6', 'UTC+7', 'ru'),
                            ('Asia/Krasnoyarsk', 'UTC+7', 'UTC+8', 'ru'),
                            ('Asia/Irkutsk', 'UTC+8', 'UTC+9', 'ru'),
                            ('Asia/Yakutsk', 'UTC+9', 'UTC+10', 'ru'),
                            ('Asia/Vladivostok', 'UTC+10', 'UTC+11', 'ru'),
                            ('Asia/Sakhalin', 'UTC+10', 'UTC+11', 'ru'),
                            ('Asia/Magadan', 'UTC+11', 'UTC+12', 'ru'),
                            ('Asia/Kamchatka', 'UTC+12', 'UTC+13', 'ru'),
                            ('Asia/Anadyr', 'UTC+12', 'UTC+13', 'ru'),
                            ('Africa/Kigali', 'UTC+2', NULL, 'rw'),
                            ('Asia/Riyadh', 'UTC+3', NULL, 'sa'),
                            ('Pacific/Guadalcanal', 'UTC+11', NULL, 'sb'),
                            ('Indian/Mahe', 'UTC+4', NULL, 'sc'),
                            ('Africa/Khartoum', 'UTC+3', NULL, 'sd'),
                            ('Europe/Stockholm', 'UTC+1', 'UTC+2', 'se'),
                            ('Asia/Singapore', 'UTC+8', NULL, 'sg'),
                            ('Atlantic/St_Helena', 'UTC', NULL, 'sh'),
                            ('Europe/Ljubljana', 'UTC+1', 'UTC+2', 'si'),
                            ('Arctic/Longyearbyen', 'UTC+1', 'UTC+2', 'sj'),
                            ('Europe/Bratislava', 'UTC+1', 'UTC+2', 'sk'),
                            ('Africa/Freetown', 'UTC', NULL, 'sl'),
                            ('Europe/San_Marino', 'UTC+1', 'UTC+2', 'sm'),
                            ('Africa/Dakar', 'UTC', NULL, 'sn'),
                            ('Africa/Mogadishu', 'UTC+3', NULL, 'so'),
                            ('America/Paramaribo', 'UTC-3', NULL, 'sr'),
                            ('Africa/Sao_Tome', 'UTC', NULL, 'st'),
                            ('America/El_Salvador', 'UTC-6', NULL, 'sv'),
                            ('Asia/Damascus', 'UTC+2', 'UTC+3', 'sy'),
                            ('Africa/Mbabane', 'UTC+2', NULL, 'sz'),
                            ('America/Grand_Turk', 'UTC-5', 'UTC-4', 'tc'),
                            ('Africa/Ndjamena', 'UTC+1', NULL, 'td'),
                            ('Indian/Kerguelen', 'UTC+5', NULL, 'tf'),
                            ('Africa/Lome', 'UTC', NULL, 'tg'),
                            ('Asia/Bangkok', 'UTC+7', NULL, 'th'),
                            ('Asia/Dushanbe', 'UTC+5', NULL, 'tj'),
                            ('Pacific/Fakaofo', 'UTC-10', NULL, 'tk'),
                            ('Asia/Dili', 'UTC+9', NULL, 'tl'),
                            ('Asia/Ashgabat', 'UTC+5', NULL, 'tm'),
                            ('Africa/Tunis', 'UTC+1', 'UTC+2', 'tn'),
                            ('Pacific/Tongatapu', 'UTC+13', NULL, 'to'),
                            ('Europe/Istanbul', 'UTC+2', 'UTC+3', 'tr'),
                            ('America/Port_of_Spain', 'UTC-4', NULL, 'tt'),
                            ('Pacific/Funafuti', 'UTC+12', NULL, 'tv'),
                            ('Asia/Taipei', 'UTC+8', NULL, 'tw'),
                            ('Africa/Dar_es_Salaam', 'UTC+3', NULL, 'tz'),
                            ('Europe/Kiev', 'UTC+2', 'UTC+3', 'ua'),
                            ('Europe/Uzhgorod', 'UTC+2', 'UTC+3', 'ua'),
                            ('Europe/Zaporozhye', 'UTC+2', 'UTC+3', 'ua'),
                            ('Europe/Simferopol', 'UTC+2', 'UTC+3', 'ua'),
                            ('Africa/Kampala', 'UTC+3', NULL, 'ug'),
                            ('Pacific/Johnston', 'UTC-10', NULL, 'um'),
                            ('Pacific/Midway', 'UTC-11', NULL, 'um'),
                            ('Pacific/Wake', 'UTC+12', NULL, 'um'),
                            ('America/New_York', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Detroit', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Kentucky/Louisville', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Kentucky/Monticello', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Indiana/Indianapolis', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Indiana/Vincennes', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Indiana/Winamac', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Indiana/Marengo', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Indiana/Petersburg', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Indiana/Vevay', 'UTC-5', 'UTC-4', 'us'),
                            ('America/Chicago', 'UTC-6', 'UTC-5', 'us'),
                            ('America/Indiana/Tell_City', 'UTC-6', 'UTC-5', 'us'),
                            ('America/Indiana/Knox', 'UTC-6', 'UTC-5', 'us'),
                            ('America/Menominee', 'UTC-6', 'UTC-5', 'us'),
                            ('America/North_Dakota/Center', 'UTC-6', 'UTC-5', 'us'),
                            ('America/North_Dakota/New_Salem', 'UTC-6', 'UTC-5', 'us'),
                            ('America/Denver', 'UTC-7', 'UTC-6', 'us'),
                            ('America/Boise', 'UTC-7', 'UTC-6', 'us'),
                            ('America/Shiprock', 'UTC-7', 'UTC-6', 'us'),
                            ('America/Phoenix', 'UTC-7', NULL, 'us'),
                            ('America/Los_Angeles', 'UTC-8', 'UTC-7', 'us'),
                            ('America/Anchorage', 'UTC-9', 'UTC-8', 'us'),
                            ('America/Juneau', 'UTC-9', 'UTC-8', 'us'),
                            ('America/Yakutat', 'UTC-9', 'UTC-8', 'us'),
                            ('America/Nome', 'UTC-9', 'UTC-8', 'us'),
                            ('America/Adak', 'UTC-10', 'UTC-9', 'us'),
                            ('Pacific/Honolulu', 'UTC-10', NULL, 'us'),
                            ('America/Montevideo', 'UTC-3', 'UTC-2', 'uy'),
                            ('Asia/Samarkand', 'UTC+5', NULL, 'uz'),
                            ('Asia/Tashkent', 'UTC+5', NULL, 'uz'),
                            ('Europe/Vatican', 'UTC+1', 'UTC+2', 'va'),
                            ('America/St_Vincent', 'UTC-4', NULL, 'vc'),
                            ('America/Caracas', 'UTC-4:30', NULL, 've'),
                            ('America/Tortola', 'UTC-4', NULL, 'vg'),
                            ('America/St_Thomas', 'UTC-4', NULL, 'vi'),
                            ('Asia/Ho_Chi_Minh', 'UTC+7', NULL, 'vn'),
                            ('Pacific/Efate', 'UTC+11', NULL, 'vu'),
                            ('Pacific/Wallis', 'UTC+12', NULL, 'wf'),
                            ('Pacific/Apia', 'UTC-11', NULL, 'ws'),
                            ('Asia/Aden', 'UTC+3', NULL, 'ye'),
                            ('Indian/Mayotte', 'UTC+3', NULL, 'yt'),
                            ('Africa/Johannesburg', 'UTC+2', NULL, 'za'),
                            ('Africa/Lusaka', 'UTC+2', NULL, 'zm'),
                            ('Africa/Harare', 'UTC+2', NULL, 'zw')";

        $sql_query[] = "CREATE TABLE IF NOT EXISTS `team` (
                          `team_uid` varchar(4) NOT NULL,
                          `team_group` varchar(10) NOT NULL,
                          PRIMARY KEY (`team_uid`)
                        )";

        $sql_query[] = "REPLACE INTO `team` (`team_uid`, `team_group`) VALUES
                            ('A1', 'A'),
                            ('A2', 'A'),
                            ('A3', 'A'),
                            ('A4', 'A'),
                            ('B1', 'B'),
                            ('B2', 'B'),
                            ('B3', 'B'),
                            ('B4', 'B'),
                            ('C1', 'C'),
                            ('C2', 'C'),
                            ('C3', 'C'),
                            ('C4', 'C'),
                            ('D1', 'D'),
                            ('D2', 'D'),
                            ('D3', 'D'),
                            ('D4', 'D'),
                            ('WA', 'QF'),
                            ('WB', 'QF'),
                            ('WC', 'QF'),
                            ('WD', 'QF'),
                            ('RA', 'QF'),
                            ('RB', 'QF'),
                            ('RC', 'QF'),
                            ('RD', 'QF'),
                            ('W25', 'SF'),
                            ('W26', 'SF'),
                            ('W27', 'SF'),
                            ('W28', 'SF'),
                            ('W29', 'F'),
                            ('W30', 'F')";
        
        $sql_query[] = "CREATE TABLE IF NOT EXISTS `shoutbox` (
                          `id` int(11) NOT NULL AUTO_INCREMENT,
                          `account_id` bigint(20) NOT NULL,
                          `username` varchar(24) NOT NULL,
                          `message` varchar(255) NOT NULL,
                          `postedon` int(11) NOT NULL,
                          PRIMARY KEY (`id`)
                        )";
        $timestamp = now();                
        $sql_query[] = "REPLACE INTO `shoutbox` (
                        `id` ,
                        `account_id` ,
                        `username` ,
                        `message` ,
                        `postedon`
                        )
                        VALUES (
                        NULL , '0', 'Schop', 'Installatie Versie 1.6 succesvol!', '$timestamp'
                        )";
        
		$sql_query[] = "CREATE TABLE IF NOT EXISTS `pool_config` (
                          `setting_uid` int(11) NOT NULL AUTO_INCREMENT,
                          `setting` varchar(255) NOT NULL,
                          `value` varchar(255) DEFAULT NULL,
                          `is_writeable` int(11) NOT NULL DEFAULT '1',
                          `category` int(11) NOT NULL DEFAULT '0',
                          PRIMARY KEY (`setting_uid`),
                          UNIQUE KEY `setting` (`setting`)
                        )";
		
		$sql_query[] = "REPLACE INTO `pool_config`
					  (`setting`,`value`, `is_writeable`,`category`)
					  VALUES
					  ('version','1.6',0,0),
					  ('pool_name','Euro 2012 Voetbalpool',1,0),
					  ('time_offset','0',1,0),
					  ('predictions_open','1',1,0),
					  ('predictions_open_offset','0',1,0),
					  ('public_predictions','1',1,0),
					  ('public_social_links','1',1,0),
					  ('sign_up_email_admin','1',1,0),
					  ('verify_users','1',1,0),
					  ('email_from_address','info@voetbalpool.nl',1,0),
					  ('play_for_money','0',1,0),
					  ('payment_per_user','10',1,0),
					  ('currency','€',1,0),
					  ('payout_schedule','50,30,20',1,0),
                      ('enable_shoutbox','1',1,0),
					  ('pred_points_goals','3',1,1),
					  ('pred_points_result','2',1,1),
					  ('pred_points_qf_team','7',1,1),
					  ('pred_points_sf_team','9',1,1),
					  ('pred_points_f_team','13',1,1),
					  ('pred_points_qf_team_wrong_pos','3',1,1),
					  ('pred_points_sf_team_wrong_pos','4',1,1),
					  ('pred_points_f_team_wrong_pos','6',1,1),
					  ('pred_points_bonus','15',1,1),
					  ('pred_points_champion','20',1,1),
					  ('ssl_enabled','0',1,2),
					  ('sign_in_recaptcha_enabled','0',1,2),
					  ('sign_in_recaptcha_offset','3',1,2),
					  ('sign_up_recaptcha_enabled','1',1,2),
					  ('sign_up_auto_sign_in','0',1,2),
					  ('sign_out_view_enabled','1',1,2),
					  ('openid_file_store_path','system/cache',1,3),
					  ('openid_google_discovery_endpoint','http://www.google.com/accounts/o8/id',1,3),
					  ('openid_yahoo_discovery_endpoint','http://www.yahoo.com/',1,3),
					  ('third_party_auth_providers','facebook,twitter',1,3),
					  ('openid_what_is_url','http://openidexplained.com/',1,3),
					  ('password_reset_expiration','1800',1,2),
					  ('password_reset_secret','ED95244060F22EE456022E091CBCE39BCD177E3992FFB61D1E3B455DAA4EF7B7',1,2),
					  ('recaptcha_public_key','6LdFA8sSAAAAAOITG6KpgretCNakHS1aEciP2176',1,2),
					  ('recaptcha_private_key','6LdFA8sSAAAAAIJfViuwlcCsz72Dp6fnRxGo5UCn',1,2),
					  ('recaptcha_theme','clean',1,2),
					  ('twitter_consumer_key','',1,3),
					  ('twitter_consumer_secret','',1,3),
					  ('facebook_app_id','',1,3),
					  ('facebook_secret','',1,3),
                      ('pool_style','',1,0)";
		
        foreach ($sql_query as $query)
        {
            $q = $this->db->query($query);
        }
        
        $tables = $this->db->list_tables();
        
        $this->load->helper('language');
        echo "<p class='success'>".lang('created_table').":<br/>";
        foreach ($tables as $table)
        {
           echo $table." - ";
        }
        echo "</p>";
?>       
    <h2><?php echo lang('create_first_account');?></h2>
    <?php
    
    $this->load->helper('form');
    $attributes = array('id' => 'validateMe');
    echo form_open('install/install/create_admin', $attributes);
    echo "<div style='text-align: right' class='grid_3 alpha'>".lang('username')."</div>";
    echo "<div class='grid_7 omega'>".form_input(array('name' => 'username',
                                                       'id' => 'username', 'minlength' => '2',
                                                       'maxlength' => '24',
                                                       'class' => 'required text'))."</div>";
    echo "<div class='clear'></div>";
    echo "<div style='text-align: right' class='grid_3 alpha'>".lang('first_name')."</div>";
    echo "<div class='grid_7 omega'>".form_input(array('name' => 'first_name',
                                                       'id' => 'first_name', 'minlength' => '2',
                                                       'maxlength' => '24',
                                                       'class' => 'required text'))."</div>";
    echo "<div class='clear'></div>";
    echo "<div style='text-align: right' class='grid_3 alpha'>".lang('last_name')."</div>";
    echo "<div class='grid_7 omega'>".form_input(array('name' => 'last_name',
                                                       'id' => 'last_name', 'minlength' => '2',
                                                       'maxlength' => '24',
                                                       'class' => 'required text'))."</div>";
    echo "<div class='clear'></div>"; 
    echo "<div style='text-align: right' class='grid_3 alpha'>".lang('email')."</div>";
    echo "<div class='grid_7 omega'>".form_input('email', set_value('email'),"class='email required'")."</div>";
    echo "<div class='clear'></div>";
    echo "<div style='text-align: right' class='grid_3 alpha'>".lang('password')."</div>";
    echo "<div class='grid_7 omega'>".form_password(array('name' => 'password',
                                                          'id' => 'password',
                                                          'minlength' => '6',
                                                          'class' => 'required text'))."</div>";
    echo "<div class='clear'></div><br/>";
    echo "<div class='grid_7 omega prefix_3'>".form_submit('create',lang('create_admin_account'),'class="button save"')."</div>";
    ?>
    </div>
    
</div>
